How to upgrade mySQL from 5.1 to 5.5

[qpidity]

Hi,

I was wondering if anyone could offer advice on how to upgrade mySQL from version 5.1 to version 5.5 on linux. We're running CentOS version 6.3 with Plesk 11.09.

The approach outlined here http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html seems like the way to go but I've been unable to verify the best practice method suggested by the Plesk community. I want to be sure that I don't adversely affect our installation.

If it is at all relevant we're running a Joomla 2.5 site.

Thanks in advance

 

[IgorG]

You may try to use this solution, for example - https://www.atomicorp.com/wiki/index.php/Mysql

 

[qpidity]

Hi Igor,

Thank you for your suggestion. Is that the solution recommended by Plesk?

There is no mention there of running any sort of backup. I read elsewhere that running a mysqldump was advisable. Is it necessary with this approach?

Thanks again

 

[UFHH01]

Before making any system relevant changes, it is ALWAYS wise to make a backup, so that you may restore the previous configuration in case of issues/failures/problems.

 

[IgorG]

Hi Igor,

Thank you for your suggestion. Is that the solution recommended by Plesk?

Yes, Atomic is old and good partner of Parallels.

 

[qpidity]

Thanks Igor, much appreciated.