Detailed steps for upgrading mysql8.0.11 to mysql8.0.17 under win2008

Time:2021-2-22

Upgrade background:

In order to solve the vulnerability of the lower version of MySQL, we upgraded from MySQL 5.5 to 8.0.11, and then to 8.0.17 (released on July 22, 2019)

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

After learning, we learned that:

There are two ways to upgrade MySQL: in situ upgrade and logical upgrade. There is no difference in essence between these two upgrading methods. It’s just that there are some differences in the processing of data files. In situ upgrade is to copy the data file directly, while the logical upgrade is to export and import the data file through logic, which needs mysqldump.

We all understand that logic upgrade takes a long time in the case of large amount of data. So today we’re going to talk about upgrading in place.

Upgrade in place:

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

After decompression, the following is true: you will find that there is no data file and my.ini configuration file

2. The previous version of mysql8.0.11 data file and my.ini Copy the configuration file to mysql8.0.17

Note: the configuration file of mysql8.11 is consistent with that of mysql8.0.17, and there is no need to modify it.

3. Uninstall the existing mysql8.0.11 service

First stop the existing MySQL service, net stop mysql

Open the CMD window, enter the bin file path under mysql, and remove the MySQL service (mysql8.0 is my service name)

4. Add the service of mysql8.0.17 to the service queue of win, and start the MySQL service

You can see the latest version of mysql8.0.17 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)

My port here is 3307, so execute the command: MySQL_ Upgrade – P 3307 – uroot – P, enter and enter the password of the last version of 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. Install and upgrade mysql8.0.17.

Note: 1 > the previous settings are still valid, just log in according to the previous settings

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

Wonderful topic sharing:

Installation of different versions of MySQL

Installation tutorial of mysql5.7

Installation tutorial of mysql5.6

Installation tutorial of mysql8.0

The above is the whole content of this article, I hope to help you learn, and I hope you can support developer more.

Recommended Today

Large scale distributed storage system: Principle Analysis and architecture practice.pdf

Focus on “Java back end technology stack” Reply to “interview” for full interview information Distributed storage system, which stores data in multiple independent devices. Traditional network storage system uses centralized storage server to store all data. Storage server becomes the bottleneck of system performance and the focus of reliability and security, which can not meet […]