Here is an outline of the steps:
- Export existing data from the old MySQL version using mysqldump
- Install the new MySQL version
- Load the dump file into the new MySQL version
- Run the mysql_upgrade utility
Here are the detailed steps:
- 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
- Shut down the MySQL server (refer to the Starting or Stopping MySQL 8 section).
- Install the new MySQL version (refer to the methods mentioned in the In-place upgrades section).
- Start the ...