How mysql 5.7.21 unzipped version recovers data through historical data directories

This article mainly shows you the "mysql 5.7.21 extracted version of how to restore data through the historical data directory", the content is easy to understand, well-organized, hope to help you solve your doubts, the following let the editor lead you to study and learn "mysql 5.7.21 extracted version of how to restore data through the historical data directory" this article.

Successfully install and generate the data file directory, set the user password and so on. The directory effect is as follows:

Let's do data recovery, which is very simple.

1. Locate the data folder under the database directory of the previous (I have been starting the unsuccessful path F:\ mysql-5.7.21-winx64) as follows:

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

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

After clicking on it, there are many watches in it.

The above is all the contents of the article "how mysql 5.7.21 decompressed version recovers data through Historical data Catalog". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!