If a server is shutdown unexpectedly (power outage or hardware failure), one or more MySQL tables can be locked open and may need to be repaired.
Browse to the folder that contains the MySQL databases:
cd /var/lib/mysql/
Check your tables by running the following command:
myisamchk *.MYI
The easiest and safest method is to run the following command (-r means “recovery mode” and -q means “quick recovery mode”). This command will not touch the data within the database:
myisamchk -r -q tbl_name
A more difficult repair to run is as follows. This command will delete damaged data:
myisamchk -r tbl_name
Reference http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html for more information.
