How to import files in frm, myd, myi format into MySQL

When using a virtual server, the server provider generally does not look like we use a local database: Use Import export (such a file suffix is *.sql). Most of the time it is a folder, which includes: Database name folders, folders included, *.frm,*. myi,*. MyD, and contains a db.opt file. Introduce each:
*.frm--describes the structure of the table
*. Index of myi--table
*.myd--saved the data records of the table
db.opt--is opened with a text editor, and you can see that the encoded information is stored inside;
Frm,myd,myi is a file that is part of the MySQL store data, phpMyAdmin cannot be imported.
The file format supported by phpMyAdmin is a SQL file.

It's actually very simple:

1. Find your MySQL installation directory under the Data folder, create a new folder, folder name is the name of the library you want to design, put these files into this folder.
2. Then you can use your management MySQL tool to see what the table is.
frm format myd format myi file is the file that MySQL uses to hold the table, so it can only be placed in the MySQL installation directory of the data directory
And if you're going to upload space, it's basically impossible to recover unless you give the data to the space trader to help you recover.

Add:

In fact, a. frm file is a table in the corresponding database that represents the table structure of the datasheet.
. MyD file This should be a data file outside the InnoDB engine.
. Myi file:. myi is the extension of the index of the MyISAM table.
With a large number of select operations on the database, use the MyISAM table
The operation of the database has a large number of insert or update, using the InnoDB table