Importing frm files from MySQL

A few days ago, my beloved Windows Server 2003 system suddenly crashed and everything was loaded. Fortunately, I installed a dual system, and I still had a system to use. I tried a lot of methods in the recovery process. then I went to Baidu to search for MySQL to import the frm file and finally found a solution! Remember this here, in case you forget it. I also hope to help the persons who need help start the following steps: Install a MySQL in the new system and create a folder in the data under the new MySQL directory, the folder name is the name of the database. stop MySQL first. you can use net stop MySQL to stop MySQL and copy the frm of the database to the new folder. next, copy the ibdata1 file under the Data Directory of the original MySQL database to the data directory under the new MySQL directory to overwrite the original one. It is best to back up the original one to prevent MySQL from being started. (I don't know. It's just a precaution. I can start it.) Then I can start MySQL! You can use net start MySQL to start MySQL.

 

 

 

Execute the SQL statement, show variables like '% dir %'; to obtain data and other related storage paths, so as to know the location where the frm file is saved.