Friday, September 9, 2011

Incorrect Information in .FRM file of MyISAM storage engine

MySQL database uses tables to store data and all these tables are defined by .FRM file. FRM is an internal file in MySQL database that contains the formating information or structure data for the database. It defines fields and structure of each MySQL's table. Regardless of the storage engine that you choose, every MySQL table is represented by .frm file. File bears the same name as table name with extension .FRM.

Example: suppose you have create a employee table in mysql database then frm file name will be employee.frm that will define the employee table.

Corruption in MySQL database table will resist you to access the table that can be happen due to several reasons like kernel bugs, unexpected power failure, hardware failure, virus attack, and many more. A corrupted table will placed the incorrect information in the frm file and you may got below error message:

Incorrect information in file: './able-name.frm'”

Resolution: you have three solutions to repair MySQL table after getting above error message:
  1. Repair corrupt table by REPAIR TABLE statement
  2. Restore from Backup
  3. Stop and copy method
Stop and copy method details
Note: if you are using MyISAM storage engine then follow the below steps to repair corrupt table:
  • Stop MySQL database
  • Take backup of your .frm, .myd, myi files.
  • Delete these files from mysql data directory.
  • Now start MySQL Database
  • Rereate table again by CREATE Table statement.
  • Stop MySQL database.
  • Copy .myd & .myi files back into the data directory, replace the ones there.
  • Start MySQL database again.
If all three methods fail to fix the corruption from table then at last you should try Stellar Phoenix MySQL repair software. MySQL repair software repairs corrupted table created using MyISAM as well as Innodb. This software has around 99 percent success rate. Its very safe and offers easy-to-use interface.

No comments:

Post a Comment