Shulou(Shulou.com)06/01 Report--

Upgrade Background:

In order to solve the vulnerability of mysql lower version, upgrade from mysql 5.5 to version 8.0.11, and upgrade to version 8.0.17 again (released from version 2019.7.22)

mysql8.0.10 and above, the installation steps are basically the same

After studying, I learned that:

MySQL upgrades are divided into two ways: in-place upgrades and logical upgrades. There was essentially no difference between these two upgrade methods. There are only some differences in the processing of data files. In-situ upgrade is to copy the data file directly, while logical upgrade processes the data file through logical export import, which requires mysqldump.

Logic upgrade everyone understands that this method takes a long time in the case of a large amount of data. So today we're going to talk about in-place upgrades.

Upgrade in situ:

1. Download the latest mysql8.0.17 version, address: https://dev.mysql.com/downloads/mysql/

After extracting, you will find that there is no data file and my.ini configuration file

2. Copy the data file and my.ini configuration file of the previous mysql version 8.0.11 to the mysql version 8.0.17 file.

Note: The configuration file of mysql8.11 is consistent with the configuration file of mysql8.0.17, and does not need to be modified.

3. Uninstall the existing mysql 8.0.11 service

Stop the existing MySQL service first, net stop MySQL

Open cmd window, enter bin file path under mysql, remove mysql service (mysql8.0 is my service name)

4. Add mysql 8.0.17 service to win service queue and start mysql service.

The latest version of mysql8.0.17, the newly installed database, can be seen in win system service manager

Start mysql8.0.17 database, net start mysql8.0.17

5. Upgrade mysql: mysql_upgrade -uroot -p (the default database port for this command is 3306)

I have port 3307 here, so execute the command: mysql_upgrade -P 3307 -uroot -p , Enter, enter the password of the previous version root

The upgrade speed depends on the size of the data directory

6. After the upgrade is successful, restart mysql8.0.17 service again

7. Installation upgrade mysql version 8.0.17 completed.

Note: 1> The previous settings are still valid, press the previous settings to log in

2> If there are multiple database services on a computer, even if you stop the previous database service, the configuration file executed when installing the new database may be changed to execute the database service that was stopped before. Delete the previous database service and the corresponding folder can be resolved

Excellent topic sharing:

mysql different versions installation tutorial

mysql5.7 installation tutorial

mysql5.6 installation tutorial

mysql8.0 installation tutorial

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of support.

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.