Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How can i upgrade mysql version 5.0.22 to version 5.0.51a ??

My server info:

Linux version 2.6.18-8.1.8.el5 (gcc version 4.1.1 20070105 (Red Hat 4.1.1-52)

Thanks

share|improve this question
    
Make sure to associate your accounts on the accounts tab on your user page. –  Dennis Williamson Jan 3 '10 at 12:49
add comment

migrated from stackoverflow.com Jan 3 '10 at 12:31

This question came from our site for professional and enthusiast programmers.

5 Answers

obviously:

yum upgrade mysql*

but, please, don't forget that:

mysqldump

is your best friend!!!

share|improve this answer
add comment

Beyond the basic (correct) answer that pulegium gave...

You are using either RHEL5 or CentOS5; enable your yum system with the IUS Community repository, it's a shared repo (like EPEL) that aims to provide newer PHP and MySQL packages that fit right into your server that was started by Rackspace employees.

Start here: http://wiki.iuscommunity.org/Doc/ClientUsageGuide

While 5.0.51a is the latest Red Hat provides, IUS is providing 5.0.88 as of this writing.

share|improve this answer
add comment

yum upgrade mysql*

share|improve this answer
add comment

Instructions on handling mysql upgrades, regarding the db itself, are in mysql documentation. When you change minor version (eg. form 5.0.x to 5.0.y) there usually isn't very much to do (if anything at all) - although there can always be some minor tweaks here and there.

Instructions about upgrading a package on your distro are in the documentation of your distro.

All in all, I do recommend you to follow the usual updates that come with your distribution of choice. If they bundle some version of MySQL, stick with that unless you have a very good reason not to do so. For a db server, I'd upgrade the whole system rather than putting an 'external' package in the distro - but that's me.

share|improve this answer
add comment

sudo yum update mysql-5.0.51a perhaps.

Of course checking that mysql-5.0.51a is indeed the correct name in the yum repositotry for MySQL.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.