MySQL | Upgrade MySQL 5.5 to 5.6 in Ubuntu 14.04

|
| By Webner

MySql 5.5 is the default version for Ubuntu 14.04

Steps to Upgrade the mysql-server

If you have existing database in Mysql 5.5. It should be migrated automatically.

Take the backup of existing databases:

mysql> mysqldump --lock-all-tables -u root -p -all-databases > backup.sql

Uninstall the existing Mysql-server with this command:

sudo apt-get remove mysql-server*

Installation of MySql5.6

MySql 5.6 is available in the default repositories:

Sudo apt-get update
Sudo apt-get install mysql-server-5.6
Sudo apt-get install mysql-client-5.6 mysql-client-core-5.6

To restore the specific databases:

mysql -u root -p < backup.sql

Webner Solutions is a Software Development company focused on developing CRM apps (Salesforce, Zoho), LMS Apps (Moodle/Totara), Websites and Mobile apps. If you need Web development or any other software development assistance please contact us at webdevelopment@webners.com

Leave a Reply

Your email address will not be published. Required fields are marked *