I need some desperate help. I was adding new categories when my server went down and my category database appears to be 'totally' screwed up. How can I fix this? I have backups. I had about 374 categories (and now I only have 100!!).

I was thinking I could use the Import Data in Table Maintenance:Category and selecting the following:-

Import data from file (full path) and selecting delete old data first.

Will this cure my problem or is there something deeper. If this does work, then what happens to all my links? Will they remain in the categories or will they become 'lost' so to speak.

Any early help would be greatly appreciated.

Regards,

Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory

Try the following:

1) EMPTY your Category table.
2) Then IMPORT your Category table from the backup.

Regards,

Eliot Lee

Can I use the Tables Manager in Links to do that? Does the import and delete do the same thing?

Thanks in advance,


Regards,

Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory

You can use the TABLE MAINTENANCE script (editor.cgi), MySQLMan (mysql.cgi), shell commands, PHPAdmin, etc....

Whatever...doesn't really matter...but you will need to first EMPTY the Category table since if you try to simply IMPORT data from your categories.db file, it will append to the records in the Category table, thus creating duplicate records and corruption during the build process.

Regards,

Eliot Lee