Recover MySQL data without .myi file (but with .myd and .frm)

Databases
1

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?

2

You should be able to put those files into your mysql operating directory e.g /var/lib/mysql/somedbname
Then perform

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.

3