Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 26.9Mb
PDF (A4) - 26.9Mb
PDF (RPM) - 25.3Mb
HTML Download (TGZ) - 6.3Mb
HTML Download (Zip) - 6.3Mb
HTML Download (RPM) - 5.3Mb
Man Pages (TGZ) - 158.7Kb
Man Pages (Zip) - 262.0Kb
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.