MyISAM is a standard storage engine used for MySQL that is based on older ISAM code. A MyISAM table is made of three files: .frm, .MYI and .MYD. MYI (MYIndex) is the index file that MyISAM uses to store table indexes.But at times, you observe that system is unable to open the .MYI file and showing some error message.In such situations you might receive the below error message with your MyISAM table:
“can't find file: tablename.MYI”
Here, ‘tablename’ refers to the name of affected MyISAM table.
For repair and recover your file you need to third party MySQL Repair application which can be used for repairing and restoring the database.
2 comments:
MyISAM is a standard storage engine used for MySQL that is based on older ISAM code. A MyISAM table is made of three files: .frm, .MYI and .MYD. MYI (MYIndex) is the index file that MyISAM uses to store table indexes.But at times, you observe that system is unable to open the .MYI file and showing some error message.In such situations you might receive the below error message with your MyISAM table:
“can't find file: tablename.MYI”
Here, ‘tablename’ refers to the name of affected MyISAM table.
For repair and recover your file you need to third party MySQL Repair application which can be used for repairing and restoring the database.
http://MoneyandTask.com/?refid=27583
Post a Comment