MySQL 5.7.21 decompressed version of the tutorial to restore data through the historical data directory

Situation description: The database was started and shut down abnormally, resulting in the prompt "Starting" when the service was started again. I had no choice but to reinstall the unzipped version of the program.

About how to install: https://www.jb51.net/article/148140.htm Please visit this article.

The installation is successful and the data file directory is generated. The user password and other things are set. The directory effect is as follows:

The following is data recovery, which is very simple.

1. Find the data folder in the database directory (I have been unable to start the path F:\mysql-5.7.21-winx64 before), the directory is as follows:

There are many historical files in it, don't worry about the others, 1 is ibdata1, this file must be copied, 2 is the name of the database I want to restore

Shut down the mysql service, copy these two files to the data file directory of the newly installed mysql (F:\Program Files\mysql-5.7.21-winx64), restart the service, and you will find OJBK.

After clicking it, you will see that all the tables are there.

Summarize

The above is the tutorial illustration of how to recover data from the historical data directory of the decompressed version of MySQL 5.7.21. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!