Use (*.FRM *. MYD *. MYI) file Recovery MySQL Database

Save it in case you encounter it later

Today when restoring the MySQL database, see the Data folder several files, not yet. sql file, not seen, summarized under. The Data folder includes: The database name folder, including the folder, *.frm,*. myi,*. MYD, and contains a db.opt file. Introduce yourself:
*.FRM----Describes the structure of the table
*. MYI Index of----table
*.MYD----Save data records for a table
db.opt----Open with a text editor and you can see that the encoded information is stored inside

To import the above database into MySQL:

1. Install MySQL database: I installed the database is MySQL Server 5.5, installation directory selection: D:\MySQL
2. Under the D:\MySQL folder, there is a file: My.ini
3. Find a DataDir key in the My.ini file such as: datadir= "C:/programdata/mysql/mysql Server 5.5/data/"
4. Under a data folder found in 3, the Copy service provider provides the files (including *.frm,*) that are provided during the backup. myi,*. MYD,DB.OPT)
5. General restart MySQL service, in the management interface can see the structure and data of the table

Use (*.FRM *. MYD *. MYI) file Recovery MySQL Database