Repair mysql Error Incorrect information in .frm File

Published by admin on June 10, 2016

Well MySQL is used by many people to store data as it uses tables to store the data and the entire tables are defined by .frm. In MySQL, .frm is an internal file which contains the formatting information or structure data for the database. However it defines the fields and structure of each MySQL’s tables. Though you select the storage engine which you select but every MySQL table is denoted by .frm file. And one important thing is that the file contains the same name similar to table name with having an extension .FRM.

Well sometimes the MySQL database gets corrupt and users don’t have knowledge about it but when the database gets corrupt then access to the MySQL database is stopped. The corruption may be due to various reasons like hardware failure, bugs, and unexpected system shutdown along with many more. When su8ch happens then the corrupted table will be placed the incorrect information in .frm file and after that you may get the error message mentioned below:

“Incorrect information in file: ‘./able-name.frm’”

Resolution:

Here you have three solution to fix the MySQL table error. Just follow the below mentioned steps:

• Repair corrupt table by REPAIR TABLE statement
• Then restore from Backup
• At last stop and copy method

Stop and copy method details

Note: When you are using MyISAM storage engine then follow the below mentioned steps to fix the error of MySQL table:

• First stop MySQL database
• Then take backup of your .frm, .myd, myi files.
• After that delete all the files from mysql data directory.
• Then start MySQL Database
• Re-create table again by using CREATE Table statement.
• Stop MySQL database.
• Copy .myd & .myi files back into the data directory by replacing the ones there.
• At last begin MySQL database again.

When all the above mentioned steps fails to repair the error of MySQL database then you should use some professional third party software which can help you to repair the error of MySQL.

Automated solution for MySQL error 1194

For if the above stated solution does not help you to get rid of the .frm error then best alternative available is MYSQL Repair Tool is the most reliable tool to fix ‘incorrect information in .frm file’ error. It also recovers corrupted and damaged database files without backup. It also recovers stored procedures, views, indexes, tables, unique/primary keys etc. that are saved in your damaged SQL database.

STEPS TO SOLVE  ERROR of MySQL:

Step 1: Start with Stellar Phoenix Database Repair for MySQL . Software and you can see the main interface as shown below.

Step 2: Click on ‘Select’ button & then select ‘Repair corrupt database which is stored at default location of MySQL’ option to select your database from default location and then click.

Step 3: The left pane shows the preview of database and its component in a tree like structure after completing scanning process.

Step 4: After previewing your database, to start repair process click ‘Repair’ button in file menu on the main user interface. Stellar Phoenix Database Repair for MySQL dialog box appears. Click Yes.

Step 5: After successful completion of the process, a message box is displayed as ‘repair process finished successfully’. Click ‘OK’ to close the message box.

Step 6: If you want to select the database manually then select ‘Manual selection of database to repair’ option & then click browse. Browse the folder dialog box opens. Select the folder that contains database and click ‘OK’.

388 Total Views 6 Views Today