CentOS 5.4: Upgrading from MySQL 5.0 to 5.5 Safest way?

vxc69 · 09-08-2010, 08:54 AM

Hello,

I'm running MySQL 5.0 on a production server and I require to upgrade mysql to version 5.5 to get a new collation support.

What is the best procedure to follow? I cannot find MySQL 5.5 on the standard repositories. A yum install would be the safest, correct?

Thanks for any advice.

szboardstretcher · 09-08-2010, 10:41 AM

My suggestion is to install the new mysql 5.5 on a different box, dump your schemas and import them into the new db.

Fromy my experience, "In place" upgrade, could cause you all kinds of strange problems.

Also,.. mysql 5.5 isnt in the repo's yet. However, you can download the rpm from the mysql site and use yum to install it.

DrLove73 · 09-08-2010, 05:45 PM

Latest MySql version in any repository for CentOS/RHEL 5.x is version 5.1.30 in Remi Collet's repository. Please read about third party repositories on this page: http://wiki.centos.org/AdditionalResources/Repositories.

If you need anything newer, you will need to install from source.