How do I update my current MySql installation on an Ubuntu 14.04 Trusty Tahr server?

I currently have this installed: Server version: 5.5.43-0ubuntu0.14.04.1-log (Ubuntu)

I would like to update to the latest stable MySQL release. Could someone point me to a good tutorial or write the command I need to execute in the shell?

Also is there any important thing I should know about before I do this upgrade? I have several sites on this server and I don't want their databases getting corrupted by accident during the upgrade.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Julian HansenCommented:
Question #1: Why do you want to update - what will the update give you that you need but don't have?

If you have multiple databases on the server and they are all running fine then what benefit is there to doing the update. Is there some specific functionality in 5.6 that you need?

As with any update first backup your existing databases - this should be done as a matter of course.

Finally, if you really want to / have to update and you have done your backups then you can read this article which explains the process

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave BaldwinFixer of ProblemsCommented:
I agree with JulianH.  What are you expecting to gain?  For the vast majority of situations, there will be no functional difference from MySQL 5.0 to 5.7.  If all of your database are running fine on MySQL 5.5, you will probably see no difference at all by moving to 5.6.

If your current version is the 'standard' version supported by Ubuntu, you will continue to get security updates if they are needed.  If you switch to some other version, you may not.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux Distributions

From novice to tech pro — start learning today.