• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Upgrade MySQL from 5.1 to 5.5

Azurel

Silver Pleskian
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?
 
Last edited:
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.
 
Thanks!

I have add atomic repo with:
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
 
Back
Top