Question

upgrade mysql 5.5 to 5.6 ubuntu 14.04

  • Posted January 1, 2015

Hi

I wont to upgrade my mysql server on Ubuntu 14.04 from version 5.5 to 5.6 how can i do that?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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:

step 1 : take a backup

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

step 2 : remove old mysql

sudo apt-get remove mysql-server sudo apt-get autoremove

step 3 : install new version of mysql

sudo apt-get install mysql-client-5.6 mysql-client-core-5.6

sudo apt-get install mysql-server-5.6

step 4 : restore your data

mysql -u root -p < dump.sql

This one worked for me:

sudo apt-get purge mysql-server*

and after that, I did this:

sudo apt-get install mysql-server-5.6

For what it may be worth, another approach would be…

mysqldump --lock-all-tables -u root -p --all-databases > dump.sql
sudo apt-get update
sudo apt-get upgrade
sudo apt-get --purge autoremove mysql-server
sudo apt-get install mysql-server-5.6
sudo service mysql restart (or stop / start depending on current state)

I get this error sudo apt-get install mysql-server-5.6

mysql-server-5.6 : Depends: mysql-common (>= 5.6.22-1~) but 5.5.55-0ubuntu0.14.04.1 is to be installed

Hi, Anyone now how to do this in linux via CLI SSH where commands are related with sudo yum update mysql-server full detail like above replies.

thanks

Hi everyone,

In fact I do not have the same version of MySQL on my old VPS ( wheezy - MySql Server 5.6) and my new one (Jessie 8.5 - MySql 5.5) so my imports cause an errors .

I tried to make a " apt-get install mysql -server- 5.6" but it does not work : "Is only available from Reviews another source - HOWEVER The Following packages replace it: MariaDB -server- 10.0 "

But once downloaded MariaDB , it will behave like an updated or empty new configuration ?

Thank you

Please note!! If you just grabbed the DigitalOcean LAMP pre-built image and you are attempting to upgrade to MySQL 5.6 and getting this error at the end:

E: Sub-process /usr/bin/dpkg returned an error code (1)

It may simply be that you don’t have enough RAM. I was getting this error consistently on the low-end droplet with 512MB RAM and nothing worked except… with 1GB of RAM it finally worked. Here’s the simple sequence:

sudo apt-get update
sudo apt-get upgrade
sudo apt-get remove mysql-server
sudo apt-get autoremove
sudo apt-get install mysql-server-5.6

Try 1GB RAM!

Over and out.

I am using Ubuntu 14.04 with ServerPilot manager. Serverpilot installs MySQL 5.5 but I need 5.6 to run Magento 2. I tryed to upgrade but did not work and worse, I think I broke ServerPilot integration. Does anyone could run MySQL 5.6 with ServerPilot?

works for me