mysql be upgraded on plesk

[PATRICIAF5]

I am updating some application on my plesk server, but got warning related to old version of mysql.
Can mysql be upgraded on plesk server without damaging the data?

[77wmaster]

What is the current version of mysql you have on server?

[PATRICIAF5]

Originally Posted by 77wmaster

What is the current version of mysql you have on server?

The current version of mysql is Mysql 5.0, I need to upgrade to Mysql 5.1.x.

[77wmaster]

NOTE : To be on the safe side, Please take backup of your server before proceeding with the steps.

It is possible to upgrade mysql in plesk server. To achieve this you need to follow the following setups :

Set up the atomic channel

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

Upgrade to Mysql 5.1

yum upgrade mysql

Disable the BERKLEY storage engine.

Open /etc/my.cnf
comment line contains
skip-bdb

Update MySQL table

mysql_upgrade -u admin -p

Issue the following command from the shell:

mysqlcheck --check-upgrade --all-databases --auto-repair -u admin -pyouradminpassword
and
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=admin --password=youradminpassword --host=localhost --database=mysql