--Take all mysql backups
--Take all OS Level backups
mysqlsh
https://dev.mysql.com/get/Downloads/MySQL-Shell/mysql-shell_8.0.20-1ubuntu16.04_amd64.deb
https://dev.mysql.com/get/Downloads/MySQL-Shell/mysql-shell_8.0.15-1ubuntu18.04_amd64.deb
mysqlsh root@localhost:3306 -e "util.checkForServerUpgrade();"
wget https://repo.mysql.com//mysql-apt-config_0.8.15-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server
5.5 to 5.7
5.6 to 5.7
Note:- 5.7 to 8 [ This mysql_upgrade is not required, No need of Server Restart ]
mysql_upgrade -u root -p
2020-05-06T11:37:27.299770Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.
2020-05-06T11:39:09.982789Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2020-05-06T11:39:09.983676Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 1670
2020-05-06T11:39:09.983706Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql/errmsg.sys'. Check
error-message file location and 'lc-messages-dir' configuration directive.
2020-05-06T11:39:10.002368Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-05-06T11:39:11.769727Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-05-06T11:39:12.300037Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket:
'/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-05-06T11:39:12.967586Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-05-06T11:39:12.975164Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_limit=1M'.
2020-05-06T11:39:12.976318Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-05-06T11:39:16.856378Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.
root@ub16mysql-5:/etc/mysql/mysql.conf.d# mysql_upgrade -u root -p
Enter password:
--The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. --Restart is not required after upgrade.
The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.
