MySQL Forums
Forum List  »  Data Recovery

Re: Database Recovery
Posted by: addision philip
Date: April 23, 2012 04:31AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3123
April 04, 2012 12:28PM
Re: Database Recovery
1794
April 23, 2012 04:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.