Centos – Upgrading MySQL causes errors

centosMySQL

I am running Centos 5.8 (Linux 2.6.18-308.13.1.el5 on x86_64), and wish to upgrade MySQL version 5.0.95. I am using a tutorial found at http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/. When I get to the following, I get the host of errors. Seems to have something to do with going from 386 to 86×64. Can anyone help? Thanks

yum --enablerepo=remi,remi-test update mysql mysql-server

Transaction Check Error:   file /etc/my.cnf from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/info/mysql.info.gz from
install of mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from
package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql.1.gz from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqlaccess.1.gz from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqladmin.1.gz
from install of mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqldump.1.gz from install of
mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqlshow.1.gz
from install of mysql50-5.0.96-2.ius.el5.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file /etc/my.cnf from
install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/charsets/Index.xml from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/charsets/cp1250.xml from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/charsets/cp1251.xml from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/czech/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/danish/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/dutch/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/english/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/estonian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/french/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/german/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/greek/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/hungarian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/italian/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/japanese/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/korean/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/norwegian-ny/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/norwegian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/polish/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/portuguese/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/romanian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/russian/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/serbian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/slovak/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/spanish/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/mysql/swedish/errmsg.sys
from install of mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with
file from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/mysql/ukrainian/errmsg.sys from install of
mysql-libs-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/bin/mysqlaccess from install
of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/my_print_defaults.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysql.1.gz from
install of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from
package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql_config.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql_find_rows.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysql_waitpid.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqlaccess.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqladmin.1.gz
from install of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386   file
/usr/share/man/man1/mysqldump.1.gz from install of
mysql-5.5.28-1.el5.remi.x86_64 conflicts with file from package
mysql-5.0.95-1.el5_7.1.i386   file /usr/share/man/man1/mysqlshow.1.gz
from install of mysql-5.5.28-1.el5.remi.x86_64 conflicts with file
from package mysql-5.0.95-1.el5_7.1.i386

Best Answer

It looks like you've used MySQL packages from the IUS community repo. Unfortunately these packages don't appear to be 100% compatible with the original packages, and so you get broken dependencies such as this one. Remove all of the existing MySQL packages first (your databases won't be touched) and then install the packages from the remi repository (which ARE compatible and have no dependency issues).

You also need to be sure you have disabled or removed the conflicting repo (IUS).