Restore MySQL. frm,. myd, and. myi files to the database _ MySQL

Restore MySQL. frm ,. myd ,. myi files were removed from a mobile phone Forum website in the early morning. I was lucky to download the database files, but there were three files in it. frm ,. myd ,. myi file, that is, the original MySQL data file. these three files are:

• . Frm table structure file
• . Myd table data file
• . Myi table index file

So I want to restore these files to a database, but the basic method found on the Internet is one way, which is troublesome to operate.

Then I found a method as follows:

1. Create a database
2. Find datadir in my. ini, name the storage location of the database file, and open this folder.
3. Create a folder. the folder name is the same as the name of the created table.
4. Copy the three files

OK. refresh the database and it will pop up.

References: http://www.cftea.com/c/2010/09/IRYY0J1QVOOR0PFC.asp