Atomicorp

I'm running Plesk 8.3.0 on RHEL4. I upgraded php to 5.2.5 this morning and everything seems to be running fine. So no I'm emboldened to try a mysql upgrade from 4.1.21 to 5.0.51, but am a bit intimidated by the list of incompatible changes on the mysql site:
http://dev.mysql.com/doc/refman/5.0/en/ ... m-4-1.html

Does anyone have experience with doing this on a plesk system?

You're using one running it right now

What kind of things do I need to watch out for? Was the upgrade fairly smooth? Were there plesk issues? Did you find many incompatibilities with scripts/databases on the server (I know this is very specific to each server)?

Obviously you should make sure your web applications are compatible with it first. As far as PSA, versions prior to 8.1 are not compatible with it. Otherwise its just a normal mysql update.

Security is slightly tighter in mysql 5 and there are some changes in command syntax. OsCommerce needs a small update to work with mysql5 for example, and one of our customers who had a custom-written script also needed to make a small change.

What we did was to inform all customers that we would be updating to mysql5 (and php5) to increase performance and security on such and such a date and for all customers to make sure that any installed scripts would be compatible and to upgrade if necessary.

Everything went smoothly.

Another one for the list, Xcart 4.1.9+ is compatible with Mysql 5 now.

I don't think zen-cart officially supports 5.x yet but it seems to run fine with it.

The biggest thing I noticed was there were a few new reserved words that caused some problems with custom coded apps.

Now after making a fresh install of CentOS 4.4 > Install Plesk 8.2.1> Update To Plesk 8.3 > Update System > Install ART Channels > Update PHP To 5.2.5 > Update MySQL .... ERROR!


Transaction Check Error:
file /usr/bin/msql2mysql from install of mysql-5.0.51 -1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/bin/mysql_find_rows from install of mysql-5.0.51-1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/bin/mysql_tableinfo from install of mysql-5.0.51-1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/bin/mysqlaccess from install of mysql-5.0.51-1.el4.art conflicts wit h file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/info/mysql.info.gz from install of mysql-5.0.51-1.el4.art conf licts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/man/man1/mysql.1.gz from install of mysql-5.0.51-1.el4.art con flicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-5.0.51-1.el4.a rt conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-5.0.51-1.el4.ar t conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/man/man1/mysqldump.1.gz from install of mysql-5.0.51-1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.0.51-1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /etc/my.cnf from install of mysql-libs-5.0.51-1.el4.art conflicts with fi le from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.0.51- 1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/cp1251.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/cp1256.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/cp1257.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/cp850.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/cp852.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/cp866.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/dec8.xml from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/geostd8.xml from install of mysql-libs-5.0.51-1 .el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/greek.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/hebrew.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/hp8.xml from install of mysql-libs-5.0.51-1.el4 .art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-libs-5.0.51-1 .el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/koi8r.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/koi8u.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/latin1.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/latin2.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/latin5.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/latin7.xml from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/macce.xml from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/macroman.xml from install of mysql-libs-5.0.51- 1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/charsets/swe7.xml from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/czech/errmsg.sys from install of mysql-libs-5.0.51-1.el4 .art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/danish/errmsg.sys from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/dutch/errmsg.sys from install of mysql-libs-5.0.51-1.el4 .art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/english/errmsg.sys from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/estonian/errmsg.sys from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/french/errmsg.sys from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/german/errmsg.sys from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/greek/errmsg.sys from install of mysql-libs-5.0.51-1.el4 .art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-libs-5.0.51-1 .el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/italian/errmsg.sys from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/japanese/errmsg.sys from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/korean/errmsg.sys from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-libs-5.0.5 1-1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-libs-5.0.51-1 .el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/polish/errmsg.sys from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-libs-5.0.51- 1.el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/romanian/errmsg.sys from install of mysql-libs-5.0.51-1. el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/russian/errmsg.sys from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/serbian/errmsg.sys from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/slovak/errmsg.sys from install of mysql-libs-5.0.51-1.el 4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/spanish/errmsg.sys from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/swedish/errmsg.sys from install of mysql-libs-5.0.51-1.e l4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-libs-5.0.51-1 .el4.art conflicts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1
file /usr/bin/mysqldumpslow from install of mysql-server-5.0.51-1.el4.art conf licts with file from package mysql-4.1.20-3.RHEL4.1.el4_6.1

Any help would be great!

Ok... Fixed...

I removed the following and was able to do yum update mysql

--> Populating transaction set with selected packages. Please wait.
---> Package mysql-bench.x86_64 0:4.1.20-3.RHEL4.1.el4_6.1 set to be erased
---> Package mysqlclient10.i386 0:3.23.58-4.RHEL4.1 set to be erased
---> Package mysql-devel.x86_64 0:4.1.20-3.RHEL4.1.el4_6.1 set to be erased
---> Package unixODBC.i386 0:2.2.11-1.RHEL4.1 set to be erased
---> Package mysql.i386 0:4.1.20-3.RHEL4.1.el4_6.1 set to be erased
--> Running transaction check

Note that I am running CentOS 4.4 x64 so I removed all i386 packages and any extra packages.... Now off to test my Plesk install...