Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 27.1Mb
PDF (A4) - 27.2Mb
PDF (RPM) - 26.0Mb
HTML Download (TGZ) - 6.5Mb
HTML Download (Zip) - 6.5Mb
HTML Download (RPM) - 5.6Mb
Man Pages (TGZ) - 152.8Kb
Man Pages (Zip) - 254.9Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

2.11.1 Upgrading MySQL

This section describes how to upgrade to a new MySQL version.


User Comments
  Posted by Craig Manley on August 8, 2016
As part of the "Logical Upgrade", I had to add the --flush-privileges option when dumping because mysql didn't recognise the newly created users when restoring views. Additionally I added --triggers for completeness.
mysqldump --add-drop-table --routines --events --triggers --flush-privileges --all-databases --force -uroot -p > mysql_backup.sql

Furthermore, if you're using Debian linux, then you'll have to copy the password of the old debian-sys-maint user in /etc/mysql/debian.cnf to the new server, or login to mysql as root and replace the old password with the new one.
Sign Up Login You must be logged in to post a comment.