Upgrade MySQL from 5.1 to 5.5

[Azurel]

Hi, I have 11.5.30#5 and want upgrade mysql to newest version. What is here the recommend way in centOS6.4?
This is my first upgrade of MySQL.

# rpm -q mysql mysql-server

result:
mysql-5.1.69-1.el6_4.x86_64
mysql-server-5.1.69-1.el6_4.x86_64

# rpm -qi mysql | grep Vendor

result:
Version : 5.1.69 Vendor: CentOS

I found this tutorial: http://www.webtatic.com/packages/mysql55/

# yum install mysql.`uname -i` yum-plugin-replace

result:
Installed:
yum-plugin-replace.noarch 0:0.2.5-2.ius.w6

# yum replace mysql --replace-with mysql55

result:
WARNING: Unable to resolve all providers: ['config(mysql-libs)', 'libmysqlclient.so.16()(64bit)', 'libmysqlclient.so.16(libmysqlclient_16)(64bit)', 'libmysqlclient_r.so.16()(64bit)', 'libmysqlclient_r.so.16(libmysqlclient_16)(64bit)', 'mysql-libs(x86-64)', 'mysql(x86-64)', 'config(mysql-server)', 'ha_archive.so.0()(64bit)', 'ha_blackhole.so.0()(64bit)', 'ha_example.so.0()(64bit)', 'ha_federated.so.0()(64bit)', 'ha_innodb_plugin.so.0()(64bit)', 'mysql-server(x86-64)']

This may be normal depending on the package. Continue? [y/N]

Why this many warnings? Should I say yes or must be fix something?


Another try:

# yum upgrade mysql

result:
No Packages marked for Update

# yum list installed | grep -i mysql

result:
mysql.x86_64 5.1.69-1.el6_4 @updates
mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 @base
mysql-libs.x86_64 5.1.69-1.el6_4 @updates
mysql-server.x86_64 5.1.69-1.el6_4 @updates
perl-DBD-MySQL.x86_64 4.013-3.el6 @base
php-mysql.x86_64 5.3.3-23.el6_4 @updates

I found this tutorial: http://www.akro.com.au/?p=329
Should I try this?

 

[Azurel]

Same question like Andy Goldschmidt in comments:
http://download1.parallels.com/Ples...inistrator-guide/index.htm?fileName=72042.htm

What is the correct way to upgrade mysql from 5.1 to 5.5 without break with plesk? Thanks for help.

 

[Nikolay.]

I think nobody tested Plesk with MySQL from Webstatic repo. You're pretty much on your own here. You'll have better luck using Atomic or Remi.

 

[Azurel]

Thanks!

I have add atomic repo with:

wget -q -O - http://www.atomicorp.com/installers/atomic | sh

Now try again:

yum upgrade mysql

result:
Dependency Installed:
libaio.x86_64 0:0.3.107-10.el6 mysqlclient16.x86_64 0:5.1.59-2.el6.art t1lib.x86_64 0:5.1.2-6.el6_2.1

Updated:
mysql.x86_64 0:5.5.32-19.el6.art

Dependency Updated:
mysql-libs.x86_64 0:5.5.32-19.el6.art mysql-server.x86_64 0:5.5.32-19.el6.art
php.x86_64 0:5.3.25-18.el6.art php-cli.x86_64 0:5.3.25-18.el6.art
php-common.x86_64 0:5.3.25-18.el6.art php-gd.x86_64 0:5.3.25-18.el6.art
php-imap.x86_64 0:5.3.25-18.el6.art php-mbstring.x86_64 0:5.3.25-18.el6.art
php-mysql.x86_64 0:5.3.25-18.el6.art php-pdo.x86_64 0:5.3.25-18.el6.art
php-tidy.x86_64 0:5.3.25-18.el6.art php-xml.x86_64 0:5.3.25-18.el6.art

Is it neccessary to execute "mysql_update"? I try it with:

mysql_upgrade -u root

result:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed

 

[Nikolay.]

If you meant this:

# mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `

then it is highly recommended.

 

[Azurel]

Thank you very much! Working fine. raise: