Saturday, 16 May 2015

Upgrade MySQL 5.5 to MySQL 5.6

MySQL 5.6 has many enhancements, especially for InnoDB.
Whatever you reason to upgrade, here is how to do it:

1. Backup your data
mysqldump --lock-all-tables -u root -p --all-databases > /backupMySQL.sql

2. Uninstall MySQL 5.5
sudo apt-get remove mysql-server
sudo apt-get autoremove

3. Install MySQL 5.6
sudo apt-get install mysql-client-5.6 mysql-client-core-5.6
sudo apt-get install mysql-server-5.6

4. Restore your data
mysql -u root -p < /backupMySQL.sql

That's it. Now enjoy FULLTEXT on InnoDB and other MySQL 5.6 features!

No comments:

Post a Comment