MySQL Upgrade

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
melvint91Asked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
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
 
nemws1Database AdministratorCommented:
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
 
melvint91Author Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Dave BaldwinFixer of ProblemsCommented:
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
 
melvint91Author Commented:
@DaveBaldin - when you say backup system... is that the same as using mysqldump() command?
0
 
nemws1Connect With a Mentor Database AdministratorCommented:
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
 
nemws1Database AdministratorCommented:
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
 
Dave BaldwinFixer of ProblemsCommented:
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
 
melvint91Author Commented:
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
 
nemws1Connect With a Mentor Database AdministratorCommented:
I would *not* remove your current version (if you can).  Try to install over the old location.  For me, that usually works better.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.