How to update the MySQL from version 4 to 5 under CentOS 4.4

[churchman]

Hi guys,

I have installed CentOS 4.4 and updated it using yum.

Currently the MySQL Server version is 4, how can I update it from 4 to 5?

[gerald_clark]

Please read the required threads.
http://www.centos.org/modules/newbb/viewforum.php?forum=47

The MySQL version will not change for CentOS 4.
Changing it will likely break other programs.

You would be better off with CentOS 5.2.

[toracat]

Actually... CentOS does offer MySQL 5 in the CentOS Web Stack. Set up the CentOS Plus repository by following the guidelines at:

http://wiki.centos.org/AdditionalResources/Repositories/CentOSPlus

It has a link to the Web Stack:

http://wiki.centos.org/AdditionalResources/Repositories/CentOSPlus/CentOSWebStack

[gerald_clark]

Good point Toracat. The Web Stack replaces those programs that would have been broken
by just updating MySQL.

Churchman, is there a reason you are not using Version 5 of CentOS?

[WeeHughie]

I have been trying to upgrade MySQL on Centos 4.7 from MySQL 4 to 5, using Centosplus. However, I get the following error and am wondering if anyone can advise:

Transaction Check Error: file /etc/my.cnf from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/README from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/cp1251.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/cp1256.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/cp1257.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/cp850.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/cp852.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/cp866.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/dec8.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/geostd8.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/greek.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/hebrew.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/hp8.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/koi8r.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/koi8u.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/latin1.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/latin2.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/latin5.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/latin7.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/macce.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/macroman.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/charsets/swe7.xml from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/czech/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/danish/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/dutch/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/english/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/estonian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/french/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/german/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/greek/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/italian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/japanese/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/korean/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/polish/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/romanian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/russian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/serbian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/slovak/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/spanish/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/swedish/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-libs-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/bin/mysqldumpslow from install of mysql-server-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/bin/msql2mysql from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/bin/mysql_find_rows from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/bin/mysql_tableinfo from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/bin/mysqlaccess from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/info/mysql.info.gz from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/man/man1/mysql.1.gz from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/man/man1/mysqldump.1.gz from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.0.68-1.el4_6 conflicts with file from package mysql-4.1.22-2.el4
file /etc/php.ini from install of php-common-5.1.6-3.el4s1.10 conflicts with file from package php-4.3.9-3.22.12

[WeeHughie]

An update - discovered I had two mysql-4.1.22-2.el4.i386 as well as x86_64.

After removing the i386 package and retrying yum update mysql* using centosplus repository, all the error messages are gone except this one:

Transaction Check Error: file /etc/php.ini from install of php-common-5.1.6-3.el4s1.10 conflicts with file from package php-4.3.9-3.22.12

******

I've checked and there is only the x86_64 versions of php* on the system.

I'm really not sure what the safest thing to do is, to get the newer versions and would appreciate some advice :)

[AlanBartlett]

Running the command [b]rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}\n" php-\* | sort[/b] [i]may[/i] through some light on the problem.

[WeeHughie]

Thanks, Alan. Here's the output - I don't see anything odd:

rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}\n" php-\* | sort
php-gd-4.3.9-3.22.12.x86_64
php-ldap-4.3.9-3.22.12.x86_64
php-mysql-4.3.9-3.22.12.x86_64
php-odbc-4.3.9-3.22.12.x86_64
php-pear-4.3.9-3.22.12.x86_64
php-pgsql-4.3.9-3.22.12.x86_64

and without the '-':

[root@cinqo etc]# rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}\n" php\* | sort
php-4.3.9-3.22.12.x86_64
php-gd-4.3.9-3.22.12.x86_64
php-ldap-4.3.9-3.22.12.x86_64
php-mysql-4.3.9-3.22.12.x86_64
php-odbc-4.3.9-3.22.12.x86_64
php-pear-4.3.9-3.22.12.x86_64
php-pgsql-4.3.9-3.22.12.x86_64

[AlanBartlett]

Perhaps you could try [b]mv /etc/php.ini /etc/php.ini-v4[/b] before re-running the [b]yum update mysql*[/b] command?

I can't think of anything else to suggest, sorry.

[WeeHughie]

Thanks for the suggestion Alan, but no - that does not work.