By tokar93
Hi
I wont to upgrade my mysql server on Ubuntu 14.04 from version 5.5 to 5.6 how can i do that?
This textbox defaults to using Markdown to format your 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.
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
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
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
