To Nha Notes | Feb. 5, 2024, 4:45 p.m.
MySQL Shell's Upgrade Checker Utility detects incompatibilities between database versions that must be addressed before performing the upgrade. The util.checkForServerUpgrade() function verifies that MySQL server instances are ready to upgrade. Connect to the existing MySQL server and select the MySQL Server version you plan to upgrade to for the utility to report issues to address prior to an upgrade. These include incompatibilities in data types, storage engines, and so on.
You are ready to upgrade when the upgrade checking utility no longer reports any issues.
How to install on Ubuntu
sudo snap install mysql-shell
How to run checker utility
mysqlsh -- util checkForServerUpgrade <DB_USER>@127.0.0.1:3306 --target-version=8.0.23 --output-format=JSON
mysqlcheck --host 127.0.0.1 --port 3306 --databases <DB_NAME> --user <DB_USER> --check-upgrade -p