Atomicorp

Posted: **Sat Jun 07, 2008 7:45 am**

Since installing your repo I cannot get MySQL to update and get the following errors

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

please advise.

Posted: **Sat Jun 07, 2008 8:56 am**

Is that an x86_64 system?

Posted: **Sat Jun 07, 2008 10:55 am**

Yes it is CENTOS 5 64 Bit.

Posted: **Sat Jun 07, 2008 7:10 pm**

You may have both the 64-bit and 32-bit versions of MySQL installed. What does the following return:

Code: Select all

# rpm -q --queryformat=%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH} mysql

Posted: **Mon Jun 09, 2008 2:29 am**

breun wrote:You may have both the 64-bit and 32-bit versions of MySQL installed. What does the following return:
Code: Select all
# rpm -q --queryformat=%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH} mysql

I think you are right as it returns

mysql-5.0.22-2.1.0.1.x86_64mysql-5.0.22-2.1.0.1.i386

I removed the i386 package and all is ok now.

Thanks.

Posted: **Sun Jul 06, 2008 7:29 pm**

I have the same problem, but I'm a little unsure about removing anything.. If I have two versions installed, how would I know wich one is actually running? And removing one wouldn't erase any databases right? (/var/lib/mysql/)

Posted: **Mon Jul 07, 2008 3:01 am**

Removing a MySQL package will not erase any databases.

Posted: **Tue Aug 05, 2008 5:06 pm**

How do i exactly remove the i386 version of MySQL?

Whats the syntax

Thank you

UPDATE: I did it! it was just

yum remove mysql-5.0.45-7.el5.i386

and then yum upgrade

right now i have:

[root@server1 ~]# rpm -qa --qf="%{n}-%{v}-%{r}.%{arch}\n" 'mysql*' mysql-5.0.58-1.el5.art.x86_64
mysql-server-5.0.58-1.el5.art.x86_64
mysql-connector-odbc-3.51.12-2.2.x86_64
mysql-libs-5.0.58-1.el5.art.x86_64
[root@server1 ~]#

Posted: **Wed Aug 06, 2008 2:59 am**

On 64-bit machines I like to run this so rpm always shows the arch as well:

Code: Select all

echo "%_query_all_fmt %%{name}-%%{version}-%%{release}.%%{arch}" >> /etc/rpm/macros

Atomicorp

MySQL Conflicts

MySQL Conflicts

I have the same problem