mysql 145 Table is marked as crashed and should be repaired

manager Wed, 01/19/2011 - 08:33

Got error: 145: Table {sometable} is marked as crashed and should be repaired

I got the this error when trying to do a sqldump of my database.  To fix this error use the utility mysqlcheck from the command line.

This statment shows that the table is marked as crashed:

# mysqlcheck -uuser -ppass database table
mediawiki.searchindex
warning  : Table is marked as crashed
status   : OK

This statement will repair the table:

# mysqlcheck -uroot -pvisitor --auto-repair database table
database.table                              OK

Subject

MySQL