0

I currently have mysql server 5.1 installed via apt-get on my production Ubuntu 11.10 server

root@Ubuntu-1110-oneiric-64-minimal$ dpkg --get-selections | grep sql-server   
mysql-server                    install 
mysql-server-5.1                install 
mysql-server- core-5.1          install

I would like to upgrade this to 5.6, but the mysql docs seem to suggest upgrading to 5.5 first, and from there to 5.6.

I've seen various lengthy guides describing how to upgrade from 5.1 to 5.5, but they all seem to describe how to upgrade by installing the tarball rather than using the package manager. Is there a simpler to upgrade using the package manager if the current version was installed using apt-get.

Obviously I want my existing configuration and databases to be retained after the upgrade and I will be sure to backup my databases using mysqldump before performing the upgrade.

1 Answer 1

1

I'm not sure about your package management issues but wanted to point out that the docs Say that you should completely reload your data using mysqldump when upgrading from a previous minor version. So once you have your complete mysqldump w/ --all-databases --events --routines, be sure to import that into the new binaries.

1
  • That documentation is probably the most important thing to consider. You should be able to get away with an upgrade via apt, but there will be several breaking changes, all of which are described in the documentation, including removing InnoDB plugin my.cnf entries (if you are using it in 5.1) and starting mysql with --skip-grant-tables the running mysql_upgrade. If you can afford to, stick with the dump and restore like @atxdba suggests, but don't forget to back up your grants as well! May 7, 2013 at 3:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.