Updating mySQL 8.0.x: step by step guide

[sbourdon]

In order to update mySQL 8.0.x to the latest version available, simply follow these steps:

• Note: MySQL 8.0.16 or newer must be installed on your server
   

1. Download and extract Windows (x86, 64-bit), ZIP Archive from this link: https://dev.mysql.com/downloads/mysql/
2. copy «mysql-8.0.x-winx64\lib\libmysql.dll» to «mysql-8.0.x-winx64\bin\libmysql.dll»
3. rename «mysql-8.0.x-winx64\bin\mysqld.exe» to «mysql-8.0.x-winx64\bin\mysqld_z.exe»
4. copy «UniServerZ\core\mysql\my.ini» and «UniServerZ\core\mysql\us_opt.ini» to «mysql-8.0.x-winx64\»
5. copy «UniServerZ\core\mysql\bin\mysql-init.txt» to «mysql-8.0.x-winx64\bin\mysql-init.txt»
6. stop mySQL(from UniController or Windows Services [«us_mysql_1»])
7. copy the «UniServerZ\core\mysql\data\» folder to «mysql-8.0.x-winx64\data\»
8. delete (or backup) the files in the «UniServerZ\core\mysql\» folder and replace them with the ones from «mysql-8.0.x-winx64\»
9. restart mySQL (from UniController or Windows Services [«us_mysql_1»])

Hope this helps!