Solved

MySQL Upgrade

Posted on 2013-05-29
10
388 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
  • 4
  • 3
  • 3
10 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 167 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 83

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 333 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 83

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 333 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
understanding output of mysql version 2 65
MySQL left join performance 4 43
How to count in a table in php 22 43
change database name 2 36
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

792 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