Replace MySQL with the new data file InnoDB

The old format of data has basically completed its historical mission. The new database files are migrated to the original database. To facilitate the transfer, the lengthy database insertion method is no longer used, instead, the ibdata file in InnoDB is directly copied to the old MySQL location.

0. Disable the pre-replaced MySQL Service

1. Copy the ibdata File

2. Store the newly launched database in:C: \ programdata \ mysql server 5.5 \ copy the file named data to the pre-replaced computer location.

3. Open the new data folder, including HP. Err, HP. PID ib_logfile0, ib_logfile1, WN-Nt *. Err, and delete the files.

4. Restart MySQL.