Thalasar Ventures

MySQL database corruption results in error messages that are difficult to overcome. Such error messages are a threat to any organization and can result in huge loses. These loses can only be prevented if in case the DBA of that company has maintained a complete backup of the entire database. While the reasons for corruption in most cases are unknown, the solution for most of the cases remains the same. To repair any corrupted database, a DBA initially needs to check the level of corruption. Once the level is identified, the DBA needs to run the inbuilt repair command. These two steps help the database administrator to overcome database corruption and access the table records in most cases. But, there might be few instances where the database remains in corruption state and the database administrator might lose all the database records. For such cases, there is a solution named MySQL database repair tool.

The above situation occurred with me (a MySQL database administrator) when I encountered the below error message while trying open my database:

“135: No more room in record file”

The database records went missing and I could see only this error message each time I tried to open my database. With no hope left, I executed the below commands to repair my database:

CHECK TABLE TABLENAME
REPAIR TABLE TABLENAME

However, when the above commands failed, I was in the state of shock. Then a friend of mine suggested me a using a MySQL repair utility.

After extensive search on Internet, I came across a utility that completely repaired my corrupted database and also allowed me to save the repaired database on my desired location.

Few advantages that I could figured out of this MySQL repair utility are:

The repair application did not provide any harm to the original database.
The MySQL database repair utility can be used by any user, irrespective of his/her technical knowledge.
The MySQL repair application can repair both MyISAM and InnoDB tables.
The repair utility also has a demo version, which is absolutely free.

After seeing all the above advantages, I know that every MySQL database user will at least use the free version of this utility. So guys, here was my experience of database corruption and the way to come over it. Hope this article helps you to overcome database corruption.