How to convert files with the suffix frm, MYD, and myi into MySQL?

After a long time, I finally got it out. Thank you very much Baidu! So now I will sum up: Destroy hahaha

Steps:

Step 1:

To create a database in MySQL, you can use the doscommand to create a database.

Create Database dbname;

Step 2: openMy. iniFile, find the file namedDatadir, Followed by a path. Mine is:

C:/Documents and Settings/all users. Windows/Application Data/MySQL Server 5.1/data/

You can see the dbname folder under this path, copy the heap. frm,. MYD, and myi, and then at the command prompt (UseCD) Go to the bin directory under the MySQL installation directory,

Note: dbname is the name of the database I created earlier.

InputMysqldump-uroot-P dbname> dbname. SQL, Press Enter. You will be asked to enter the Database Password. after entering the password, press Enter.

Then, you can find the converted dbname. SQL in the bin directory under the MySQL installation directory.

Step 3: run the doscommand to go to the bin directory under the MySQL installation directory.

Then: EnterMysqldump-uroot-P dbname> dbname. SQLIn this case, press enter and you will be able to see it in the database... haha