. frm,.myd,myi conversion to. SQL Import Database

First of all, what are these kinds of documents:
*.FRM is a description of the structure of the table,
*.myd saves the data record of the table,
The *.myi is the index of the table.
In fact, a. frm file is a table in the corresponding database that represents the table structure of the data table.
. MyD file This should be a data file outside of the InnoDB engine.
. Myi file:. myi is the extension of the index of the MyISAM table.
The operation of the database has a large number of select, using the MyISAM table
There is a large number of INSERT or update operations on the database, using the InnoDB table

MySQL installation path Below a My.ini, with Notepad open find DataDir, followed by the path, my c:/programdata/mysql/mysql Server 5.1/data to this path can see the dbname folder , put that pile of. Frm,.myd,myi are copied in,(here you can, if not the following) and then at the command prompt into the MySQL installation directory of the bin directory, enter mysqldump-uroot-p dbname > Dbname.sql, execute, note: dbname is the name of the database I created earlier. After that you will find a dbname.sql in the bin directory, how, simple. But when I was using it, I found the command prompt to use the CD command has not been able to enter the bin directory, and even can not change the current directory, I do not know why, because of the installation of MySQL? Double-click mysqldump.exe,cmd window a flash, the command can not input acridine, what to do, but also want to recruit, or use batch it, simple and convenient. Set up a TXT file in the bin directory, copy the above command, save as, select all the files in the file name, but add the extension. bat, for example "new text file. Bat", save. Double-click the bat file that you just created ...

Test:

View in Navicat.exe
Copy data file: C:\AppServ\MySQL\data\db_vote
C:\AppServ\MySQL\my.ini

The MySQL installation path has a my.ini[eg: my C:\AppServ\MySQL\my.ini], open the Find datadir with Notepad, followed by the path "C:/programdata/mysql/mysql Server 5.1/ Data, my is: c:\appserv/mysql/data/"to this path can see the dbname folder, the heap of. Frm,.myd,myi all copied in, (to here, if not, then the following)

. frm,.myd,myi conversion to. SQL Import Database