Home / server / Questions / 137960
Accepted
DrStalker
Asked: 2010-05-03 22:40:32 +0800 CST

MySQL: table is marked as crashed

  • 772

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?

mysql

3 Answers

  1. Best Answer

    To check the tables:

    CHECK TABLE mytable1

    To repair the table:

    REPAIR TABLE mytable1
    • 14

  2. Here is specifically what always fixes the table for me:

    myisamchk -o /var/lib/mysql/YourDB/yourcrashedtable.MYI

    Source: http://realtechtalk.com/MySQL_table_is_marked_as_crashed_solultion-1924-articles

    • 2

  3. Do this.

    cd /var/lib/mysql/dbname myisamchk --silent --force *.MYI

    • 0