Corrupt MySQL DB - All Tables showing as "In Use"

[elflocko]

Hi all:

I'm in a bit of a conundrum on this one. I have a MySQL 5.0 DB running on CentOS 5 that seems to have corrupted. In PHPMyAdmin, all of the tables show as "in use". When I attempt to repair them, I receive both mysql error #1017 - Can't find file with a path to the directory where it should be, as well as errno 13, which is a permissions error.

In mysqladmin, I can navigate to the DB, show the tables which appear to have data, but if I attempt even a simple SELECT, I receive the same errors.

The mysql docs have information on repairing individual tables, but I haven't seen any references for EVERY table being hosed.

Any pointers or firm nudging in the right direction would be appreciated.

Thanks in advance.

 

[DonQuichote]

Is there anything in a log file that points you to the real error?

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[hvass]

Yes sounds like file permissions or corrupted filesystem esp. as all tables seem to be affected. Have you moved them recently etc...
Worth temporarily chmod 777 to see if that makes a difference.
If you are using MYISAM engine and you look at the physical .frm files you should see the column names at the end of the file. And the .MYD file you should be able to see text fields as plain text and you should be able to work out if the physical file is being reported as about the right size - look at the average length of record x number of records.

 

[elflocko]

Thank you both for your input. I did find out the cause of the issue; cPanel\WHM put out an update that screwed up the config.inc.php file. Of course it couldn't connect because it couldn't find the socket.


Hopefully this will help someone else here.


Regards.