HELP: Some tables are corrupted

TeraSoft

Verified User
Joined
Mar 21, 2007
Messages
29
Hi,

Last night I made a successfull update to the hole system.
Everything is now up to date.
I thought it was successfull anyway, but some of the mysql tables are corrupted.
Phpmyadmin shows:

SHOW INDEX FROM `wp_categories` ;
#1033 - Incorrect information in file: './ldf_wp213/wp_categories.frm'

But this is only in some of the tables, others are working as planned.
The worst thing is, that the backup I made is now old. So I will loose data on those tables that works if I back it all up.

Do anybody have an idea? :confused:

Edit: Well I found out that removing the my.cnf fixed the problem. Why my.cnf suddenly is making this error, I dont know.
Phew :) panicked a little, not a nice way to start the day :)

(For future readers) While searching the net, many had the same problem because the /tmp dir was missing or had wrong rights.
 
Last edited:
Of course we have no idea what's in your my.cnf file. Nor do we know you updated MySQL, and if so, how, and between which versions.

But I'd be willing to guess there's a line in my.cnf that's not compatible with your updated MySQL install.

Jeff
 
Back
Top