Tuesday, January 26, 2016

Upgrade mysql in Ubuntu 14.04

https://www.digitalocean.com/community/questions/upgrade-mysql-5-5-to-5-6-ubuntu-14-04
While MySql 5.5 is the default for Ubuntu 14.04, MySql 5.6 is available in the default repositories. It can be installed simply using:
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.6
If you have existing data in a MySql 5.5 database, it should be migrated automatically. Though it is always a good idea to make a backup before doing a major upgrade.
First make a backup of the data in your existing database:
mysqldump --lock-all-tables -u root -p --all-databases > dump.sql
Then after installing the newer version, you can restore if needed by running:
mysql -u root -p < dump.sql
For more info on migrating MySql databases, check out:

No comments:

Post a Comment