MySQL: table is marked as crashed

Posted by DrStalker on Server Fault See other posts from Server Fault or by DrStalker
Published on 2010-05-03T06:40:32Z Indexed on 2010/05/03 6:48 UTC
Read the original article Hit count: 300

Filed under:

After a disk full issue one of the MySQL DBs on the server is coming up with the following error when I try to back it up:

[root@mybox ~]# mysqldump -p --result-file=/tmp/dbbackup.sql --database myDBname
Enter password:
mysqldump: Got error: 145: Table './myDBname/myTable1' is marked as crashed and should be repaired when using LOCK TABLES

A bit of investigation shows two tables have this issue.

What needs to be done to fix up the damaged tables?

© Server Fault or respective owner

Related posts about mysql