This page looks best with JavaScript enabled

Mysql repair myd and myi files!

 ·   ·  β˜• 2 min read

You can repair Mysql myd and myi files with the help of myisamchk. Myisamchk function gets information about your database tables or repairs, checks or optimizes them. Myisamchk works with MyISAM tables that have .myd and .myi files for storing indexes and data. With no options myisam simply checks your table as the default operation. You can invoke myisam like this: shell> myisamchk [options] tbl_name…

You can name many tables on the myisamchk command line if you want to. You can also specify a table by naming its index file. This allows you to specify all tables in a directory by using the pattern *.myi.

You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair mysql myd and myi files of MyISAM tables.

CHECK TABLE checks a table or table of errors. The syntax for checking tables is: CHECK TABLE tbl_name [, tbl_name] … [option] …


The syntax for repairing the table is: REPAIR [NO WRITE TO BINLOG | LOCAL] TABLE tbl_name [, tbl_name] …


Symptoms of corrupted tables include queries that terminate unpredictably and observable errors like:

  1. Unexpected end of file.
  2. . Record file is crashed.
  3. tbl_name.frm is locked against changed.
  4. Can’t find file tbl_name .MYI (Errcode: nnn)
  5. Got error nnn from the table handler.

Where nnn is the error number and the most common error numbers that indicate a problem with a table are as follows:

Mysql error code 126 = Index file is crashed.

Mysql error code 127 = Record file is crashed.

Mysql error code 132 = old database file.

Mysql error code 134 = record was already deleted.

Mysql error code 135 = no more room in record file.

Mysql error code 136 = no more room in index file.

If you are in the situation when you are unable to repair mysql myd and myi files with the above listed methods then you can opt for the stellar phoenix software. Stellar phoenix data recovery software for mysql supports myd and myi files. It recovers and repairs mysql myd and myi files. Stellar phoenix software offers an interactive interface, which makes it user friendly and easy to understand. It is easy to install and it comes with graphical documentation. You can easily download the free trail version of this software by online and can buy it from online also. This repair software establishes a secure connection with mysql server while repairing the damaged file.

Share on