MySQL 8 Cookbook

Logical Upgrades

Here is an outline of the steps:

1. Export existing data from the old MySQL version using mysqldump
2. Install the new MySQL version
3. Load the dump file into the new MySQL version
4. Run the mysql_upgrade utility

Here are the detailed steps:

1. You need to take a logical backup of the database (refer to Chapter 7, Backups for a quicker backup called mydumper):

shell> mysqldump -u root -p --add-drop-table --routines --events --all-databases --ignore-table=mysql.innodb_table_stats --ignore-table=mysql.innodb_index_stats --force > data-for-upgrade.sql

2. Shut down the MySQL server (refer to the Starting or Stopping MySQL 8 section).
3. Install the new MySQL version (refer to the methods mentioned in the In-place upgrades section).
4. Start the ...