MySQL 8 Cookbook

Using YUM repositories

1. Prepare MySQL for a slow shutdown, which ensures that the undo logs are empty and data files are fully prepared in case of file format differences between releases:

mysql> SET GLOBAL innodb_fast_shutdown = 0;

2. Shut down the mysql server as described in the Stopping MySQL 8.0 Server section:

shell> sudo systemctl stop mysqld

3. Remove the InnoDB redo log files (the ib_logfile* files) from the data directory to avoid downgrade issues related to redo log file format changes that may have occurred between releases:

shell> sudo rm -rf /var/lib/mysql/ib_logfile*

4. Downgrade MySQL. To downgrade the server, you need to uninstall MySQL 8.0, as described in the Uninstalling MySQL 8 section. The configuration files are automatically ...