Home  /  Blog  /  MySQL Recovery   /   Can not Find File: .myi – Mysql Error and Recovery

Can not Find File: .myi – Mysql Error and Recovery

MySQL Recovery, by

MySQL uses MyISAM as the default storage engine, which is based on older ISAM code but comprises many useful extensions. The MyISAM comprises three files having extensions- .frm, .MYI, and .MYD that are used to properly store the data. The MYI extension in MyISAM storage engine stands for MyIndex and refers to the index file in which table’s indexes are stored.

But, sometimes while working with MySQL, the .MYI file does not open and MySQL displays the following error message:

Can’t find file: .MYI

The specified error message is generated when .MYI file gets corrupt, which can also lead into database corruption. Following can be the reasons for .MYI file damage:

¢ Abrupt system shut down when MySQL is in use
¢ Network errors
¢ Internal code errors in MyISAM
¢ Improper tables locking
¢ Physical issues, etc.

You can repair and restore the database damaged due to corruption of .MYI file, by one of the following ways:

¢ Using Backup: Use the database backup to restore the database objects. If you do not have backup or the backup you have is not updated then consider the next process.

¢ Using MySQL Repair Commands: MySQL provides you with database repair commands so that you can tackle problem occurred due to database corruption. To use MySQL Repair commands, you first need to check the extent of database table corruption by using one of the following commands:

o CHECK TABLE table_name
o myisamchk *.MYI
o mysqlcheck *.MYI

If any corruption is detected, execute the following commands to repair the database table in which corruption is found:

o REPAIR TABLE table_name
o myisamchk *.MYI
o mysqlcheck *.MYI

After executing this process, if you still face the same error message then consider the next and the best possible way to repair damaged database file.

¢ Using MySQL Recovery Tool: When you do not have database backup and all other possible ways get failed to repair the database, the MySQL Recovery tool becomes a help for you.

With the self descriptive user interface, Kernel for SQL repair tool facilitates you to perform successful SQL server recovery and repair the damaged database file with ease. The software has been designed to perform fast and effective database recovery. Kernel for SQL recovers all database objects like tables, views, triggers, etc. with full accuracy. Moreover, the software maintains data consistency and integrity. You can install the software on Windows 7, Windows Vista, Windows XP, Windows 2003, and Windows 2000.

Leave a Reply

Your email address will not be published. Required fields are marked *