Solved

MySQL Upgrade

Posted on 2013-05-29
10
385 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
 
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
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 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

912 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now