MYSQL --Repair Tables

http://dev.mysql.com/doc/refman/5.0/en/repair.html

Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these:

• tbl_name.frm is locked against change

• Can't find file tbl_name.MYI (Errcode: nnn)

• Unexpected end of file

• Record file is crashed

• Got error nnn from table handler

To get more information about the error, run perror nnn, where nnn is the error number.

perror - describes a system or MySQL error code. 

Can  be  used  to  display a description for a system error code, or an MyISAM/ISAM table handler error code. The  error  messages  are  mostly system dependent