Shulou(Shulou.com)05/31 Report--

Editor to share with you how to restore the original database table after changing the MySQL version under Mac. I hope you will get something after reading this article. Let's discuss it together.

Application scenario: database upgrade, overwrite, uninstall and other reasons, resulting in database loss.

This recovery is due to the loss of the database caused by the version upgrade (override installation). The new version of the database is running normally, but there is no previous database in it.

Here is the installation directory

You can see that both installation directories exist, open the lower version of the directory, the data folder is very comfortable inside.

Prepare to migrate from 5.7.24 to 5.7.31

The following is to restore the lower version of the data to the higher version:

1. Copy everything under the whole data to the high version of data; it is recommended that the high version is empty-that is, newly installed; in this way, the duplicate data will be directly overwritten, and there will be no loss if other problems occur.

2. After the overwrite is completed, there is another key step to grant mysql access to the files under data.

Sudo chown-R mysql:mysql data

Well, if there is no error message, the data recovery will be successful!

Modify the configuration. MySQL startup report: [ERROR] The server quit without updating PID file

MySQL cannot be started after modified configuration. An error was reported:

Sudo chown-R mysql:mysql / usr/local/MySQL/data/sudo chmod-R 755 / usr/local/mysql/datasudo / usr/local/mysql/support-files/mysql.server restart

After reading this article, I believe you have a certain understanding of "how to restore the original database table after changing the MySQL version under Mac". If you want to know more about it, welcome to follow the industry information channel, thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.