I have a mysql data with a loss of .myi file.
I have .myd and .frm files.
How can I recover the table and data now?
You should be able to put those files into your mysql operating directory e.g /var/lib/mysql/somedbname
CHECK TABLE somedbname;
and if necessary
REPAIR TABLE somedbname;
You'll be missing the indexes which are in the .myi file (the .frm is the structure and the .myd is the data) , if you do the REPAIR TABLE it should rebuild them.
Note that .frm file is quite mysql version specific so you should only do this on the same version.
This topic is now closed. New replies are no longer allowed.