How to import the frm format myd format myi format file into MySQL

Frm,myd,myi is a file that belongs to MySQL storage data, phpMyAdmin cannot be imported.

phpMyAdmin supports file formats for SQL files.

It's actually very simple:

1. Find your MySQL installation directory in the Data folder, create a new folder, the name of the folder is the name of the library you want to design, put these files (frm,myd,myi format files) in this folder.

Tip: You can also use the MySQL management tool to create a database (for example: Create DB MyDB, where mydb is the database name), and a MyDB folder will be generated under the Data folder

2. you can then use your MySQL-managed tools to see what the table is all about.

3. You can also export SQL scripts using commands

Mysqldump-uroot-ptian mydb> Mydb.sql where root is the user name Tian the password mydb the database name mydb.sql to the script file name