Cause: Such erroneous situation occurs when the MySQL table that you are using is corrupt.
Resolution: To repair MySQL database in such case, you should perform either of the following methods:
Use updated backup: First of all, you should check if there is any clean and updated backup of the MySQL table. If yes, then restore the table with the backup.
Use Repair Table tool: If the backup is not up-to-date, then you should try to repair MySQL table using the Repair Table tool with either 'QUICK' or 'EXTENDED' repair clause. This tool can be used in the following syntax:
REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE
tbl_name [, tbl_name] ...
[QUICK] [EXTENDED] [USE_FRM]
The situation will be resolved using the aforementioned solution, however if the problem persists then this situation calls for the use of a third-party MySQL recovery software.
http://www.mysql-database-recovery.com/
Ref:
http://www.articlesbase.com/data-recovery-articles/repairing-mysql-database-when-error-1146-indicates-table-corruption-3232219.html
Edited 1 time(s). Last edit at 04/23/2012 04:33AM by addision philip.