Tuesday, September 28, 2010

Restore MyISAM tables by MySQL Recovery Software

Any corruption in MyISAM table is a terrible situation for Database Administrator. These MyISAM tables are the most important components in the MySQL Database to store personal as well as professional data, and the corruption in these tables may inaccessibility to the database. In this situation, a database backup allows you to restore the database and access the records in the table. Duplicate file (Backup) of the database is mostly stored on a different storage media, the changes of database corruption still exist. In that situation, you will need to perform MySQL database repair by the using of third party software.

Some error messages that enable you to identify that your MyISAM table (student) is corrupt:

Student.frm is locked against change
Or
Got error message student from table handler

Or
Can't find file student.MYI (Errcode: nnn)

The record saved in the student table becomes inaccessible after the above error message appears. In addition, you will receive any of the above three error messages each time when you attempt to access the table of student.

Cause of These Errors:

Few main reasons for the student table corruption are virus infection, file system damage, improper MySQL Server shutdown, human errors and many more.

How to Resolve These Errors:

To resolve above three error messages in student table and access the records, you will need to follow the below procedures:

You will have to use an in-built tool “myisamchk” to find and repair the student table records. The command-line of this tool scans the MySQL database components and found the exact cause of corruption & repairs the student tables.

You can also use several SQL commands to repair and restore the student records. Some of those commands are REPAIR TABLE, CHECK TABLE & OPTIMIZE TABLE.



The probabilities repair of student table records is very less by the using of any two above methods, but sometimes exists. Such case occurs when the student table is badly damaged at that point you (DBA administrator) will have to need advanced MySQL recovery software to repair student table.

Stellar Phoenix Database Recovery for MySQL repairs of MyISAM tables by using of advanced repairing algorithms. This software is completely read-only in nature and repairs without any modifying in the original data file. Moreover, this MySQL recovery software is easily understandable without any prior technical knowledge related to MySQL.

Source: http://hubpages.com/hub/Restore-MyISAM-tables-by-MySQL-Recovery-Software