Updating from 14.04.5 LTS to 16.04.3 LTS can be tricky in some details. The most parts will run fine during the update, but for mysql there simply isn’t a migration path from 5.5 to 5.7 directly.<\/p>\n
Before anything else, backup<\/strong> your data first!<\/p>\n First you’ll have to upgrade vom 5.5 to 5.6, this happens pretty straightforward via the provided packages:<\/p>\n The trouble is, that the packages for 5.7 are not available on Ubuntu 14.04.5 LTS. If you want to transfer the data from a host running 14.04.5 to another host running on 16.04.3, you’ll have to upgrade to 5.7 first. If you want to upgrade the host currently running your mysqld, you can just continue with To upgrade to mysql 5.7, you’ll have to leave the supported upgrade path from ubuntu 14.04 and insert your own apt-source from mysql.<\/p>\n Download the latest mysql-apt-config_w.x.y-z_all.deb from https:\/\/dev.mysql.com\/downloads\/repo\/apt\/, mine was mysql-apt-config_0.8.9-1_all.deb<\/a>.<\/p>\n If you get errors like „Couldn’t execute ‚SHOW VARIABLES LIKE ‚gtid\\_mode“: Native table ‚performance_schema‘.’session_variables‘ has the wrong structure“, you forgot to restart your mysql-server.<\/p>\n This answer from askubuntu.com<\/a> helped me work out the details.<\/p>\n","protected":false},"excerpt":{"rendered":" Updating from 14.04.5 LTS to 16.04.3 LTS can be tricky in some details. The most parts will run fine during the update, but for mysql there simply isn’t a migration path from 5.5 to 5.7 directly. Before anything else, backup your data first! mysqldump –lock-all-tables -u root -p –all-databases > backup.sql First you’ll have to … Upgrade Ubuntu 14.04.5 LTS to 16.04.3 LTS: mysql<\/span> weiterlesen \r\nmysqldump --lock-all-tables -u root -p --all-databases > backup.sql\r\n<\/pre>\n
\r\nsudo apt update\r\nsudo apt install mysql-server-5.6 mysql-client-5.6 mysql-server-core-5.6 mysql-client-core-5.6\r\n<\/pre>\n
do-release-upgrade<\/code>, the upgrade to mysql 5.7 handles the database structure upgrade just fine.<\/p>\n\r\nsudo gdebi mysql-apt-config_0.8.9-1_all.deb\r\nsudo apt update\r\nsudo apt install mysql-server\r\nmysql_upgrade -u root -p\r\nsudo service mysql restart\r\n<\/pre>\n