. frm. myd. myi files in MySQL

Yesterday saw a library management system program, found that the database files are myi,frm and myi files, not flat commonly used. sql files, which have not been used before, have not noticed this before. Online search for a bit, hehe, smoothly imported into MySQL.

First, let's introduce the. frm myd. myi file. . frm myd. Myi is a file that MySQL stores data on, represents the structure/data and index files of MySQL database tables, and we create only the database table structure files when creating databases and tables by default. frm. When you migrate a database, you must have a database table file in three formats in order for the DB to work correctly.

Open your MySQL data directory, you may also encounter another file format. Opt you can open it with a text editor and you can see that the encoded information is stored inside. Frm,myd,myi is a file that belongs to MySQL storage data, phpMyAdmin cannot be imported. phpMyAdmin supports file formats for SQL files. The following is the operation method of the relevant introduction, I hope to be helpful to everyone.

In fact, the operation is very simple:

First find your MySQL installation directory under the Data folder, generally in the C drive, for example, my is in C:\ProgramData\MySQL\MySQLServer 6.0\data\, where you can see the database you previously established, open these, uh, are . frm. myd. myi file. Create a new folder under the Data folder whose name is the name of the database and put those. frm. myd. myi files in this folder.

Then you can use your tools to see exactly what's in the table.

. frm. myd. myi files in MySQL