How to recover MySQL data after loading the system

There are times when Windows servers need to be re-installed, and many of the software needs to be reinstalled. What to do without backing up MySQL data!

Method/Step

1. 1

   To stop the MySQL service:

   Stop and start MySQL under Windows through the ' services ' item of the Admin tool (it is best to build a database in MySQL with the same name and then stop the service);

2. 2

   File copy:

   The ' MySQL ' folder within the Data folder, the ' Database name ' folder (which is the table structure with the same name as the database), ibdata1 (metadata), three copies to the newly installed MySQL Data folder;

3. 3

   Start the server:

   Delete the two log files below the Data folder (IB_LOGFILE0, Ib_logfile1 binary logs are not important), restart the MySQL server.

How to recover MySQL data after loading the system