Are there any issues upgrading to mysql 5?

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
Post Reply
dumbomaz
Forum User
Forum User
Posts: 8
Joined: Fri Sep 01, 2006 10:44 am

Are there any issues upgrading to mysql 5?

Unread post by dumbomaz »

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?
Top
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:
Contact scott

Unread post by scott »

You're using one running it right now
Top
dumbomaz
Forum User
Forum User
Posts: 8
Joined: Fri Sep 01, 2006 10:44 am

Unread post by dumbomaz »

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)?
Top
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:
Contact scott

Unread post by scott »

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.
Top
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Unread post by faris »

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.
Top
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:
Contact scott

Unread post by scott »

Another one for the list, Xcart 4.1.9+ is compatible with Mysql 5 now.
Top
Highland
Forum Regular
Forum Regular
Posts: 674
Joined: Mon Apr 10, 2006 12:55 pm

Unread post by Highland »

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.
Top
crobinson
Forum User
Forum User
Posts: 24
Joined: Sat Jan 12, 2008 6:20 pm

The Only Problem That I Am Seeing Is...

Unread post by crobinson »

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!
Top
crobinson
Forum User
Forum User
Posts: 24
Joined: Sat Jan 12, 2008 6:20 pm

Unread post by crobinson »

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...
Top
Post Reply

Return to “General Help and Development Discussion”