Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MySQL Upgrade

Posted on 2013-05-29
10
Medium Priority
?
392 Views
Last Modified: 2013-06-20
Can I upgrade MySQL from 5.0.67 to 5.6.11 without causing any major problems to the newer version. . . Is it a requirement or best practice to upgrade a version at a time from 5.0.67 to 5.6.11
0
Comment
Question by:melvint91
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 3
10 Comments
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 668 total points
ID: 39206690
MySQL recommends upgrading one release at a time.  After making complete backups of course.

http://dev.mysql.com/doc/refman/5.6/en/upgrading.html
0
 
LVL 23

Expert Comment

by:nemws1
ID: 39209255
Spin up a test environment using VirtualBox and some UNIX (Ubuntu?) and test and find out. ;-)

I will say I *have* done such upgrades and they did work, but I had some "cleanup" work (updating tables in the mysql database) that I had to do.
0
 

Author Comment

by:melvint91
ID: 39210075
The type of mysql server version installed is: 5.0.67 Source distribution. . .

Couple of questions:

1. What version is Source Distribution? at MySQL website, I see Enterprise Edition, Standard Edition, Community Server Edition, etc. . . but I can't find Source Distribution edition. . .

2. since verstion 5.0.67 is installed and I'm looking to upgrade, do I need to upgrade starting at 5.0.77  (the next upgrade) or can I start at 5.1 version.
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 39210084
You could start at 5.1 but... Source Distribution probably means it was installed by and for your version of Linux.  To upgrade on Linux usually means you either install a newer version of your Linux 'distribution' because they usually do not upgrade the MySQL version by itself.  Or you download the MySQL source code and compile and install your own version and can no longer get any security updates for it.

Both of these options have serious consequences if they fail.  So before you even consider either one of them, make sure you can make a complete backup of your system.
0
 

Author Comment

by:melvint91
ID: 39210145
@DaveBaldin - when you say backup system... is that the same as using mysqldump() command?
0
 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 1332 total points
ID: 39211311
Source distribution typically means "Community Server Edition"

And by backup, yes, use mysqldump.  If it were me, I would shut down my MySQL server process and back up (tarball) all my data files as well (/var/lib/mysql on most Linux boxes).  You don't want to back this up while the server is running, because you can't guarantee the states of the files (some of them might be written to while you are trying to back them up).
0
 
LVL 23

Expert Comment

by:nemws1
ID: 39211317
If you wanted to go to 5.1, then 5.5 before 5.6, that would probably be a decent idea.  You can get any old version of MySQL here:

http://downloads.mysql.com/archives.php

Again, I recommend setting up a test environment with these (Virtualbox and Linux distros are free) and testing the upgrade.  Its usually work the time, IMO.
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 39211549
No, I mean backup your entire computer system so you can restore it if you need to.  What operating system and distribution are you using?  If you are using Linux, I suggest you click on "Request Attention" above and get more zones and experts to look at this question.  Upgrading on Windows is fairly easy, you just download and install.  It is not so easy on Linux, especially if you have a live working system that people are using.
0
 

Author Comment

by:melvint91
ID: 39221957
The update will be done on a Solaris 10 OS. . .I plan to upgrade to MySQL 5.6.11 using the following downloaded file: mysql-5.6.11-solaris10-sparc-64bit.tar...

Would it be easier to just backup my database using mysqldump(), then remove the current version of MySQL, then do a new install of MySQL with the most current version... In this database, I only have about 1500 records total...
0
 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 1332 total points
ID: 39222214
I would *not* remove your current version (if you can).  Try to install over the old location.  For me, that usually works better.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question