MySQL Update on Plesk 8.3 FC6

[sparkybarkalot]

I'm trying to update MySQL using yum and getting some conflict errors, so I ran "rpm -qi mysql" and it looks like I have two versions of MySQL 5.0.27 installed? This may be a boneheaded question, but how do I uninstall the non-ART MySQL without messing things up on my server? Here's the output from "rpm -qi mysql", and thanks for any suggestions:

Name : mysql Relocations: (not relocatable)
Version : 5.0.27 Vendor: http://www.atomicrocketturtle.com/
Release : 1.fc6.art Build Date: Mon 19 Mar 2007 02:14:47 PM EDT
Install Date: Mon 01 Oct 2007 10:41:04 PM EDT Build Host: build.atomicorp.com
Group : Applications/Databases Source RPM: mysql-5.0.27-1.fc6.art.src.rpm
Size : 8684129 License: GPL
Signature : DSA/SHA1, Tue 20 Mar 2007 10:39:41 AM EDT, Key ID 32a951145ebd2744
Packager : Scott Shinn <scott@atomicrocketturtle.com>
URL : http://www.mysql.com
Summary : MySQL client programs and shared libraries.
Description :
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. The base package
contains the MySQL client programs, the client shared libraries, and
generic MySQL files.

Name : mysql Relocations: (not relocatable)
Version : 5.0.27 Vendor: Red Hat, Inc.
Release : 1.fc6 Build Date: Thu 23 Nov 2006 12:42:34 AM EST
Install Date: Mon 01 Oct 2007 10:41:05 PM EDT Build Host: ls20-bc2-14.build.redhat.com
Group : Applications/Databases Source RPM: mysql-5.0.27-1.fc6.src.rpm
Size : 6046483 License: GPL
Signature : DSA/SHA1, Mon 27 Nov 2006 10:01:19 AM EST, Key ID b44269d04f2a6fd2
Packager : Red Hat, Inc. <http://bugzilla.redhat.com/bugzilla>
URL : http://www.mysql.com
Summary : MySQL client programs and shared libraries.
Description :
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. The base package
contains the MySQL client programs, the client shared libraries, and
generic MySQL files.

[scott]

This an x86_64 box?

[sparkybarkalot]

Yes, it is an x86_64 box

[scott]

I'll bet that 2nd one is the i386 version then.

[breun]

I do this on all our 64-bit boxes:

Code: Select all

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

Now run rpm -q mysql again and see what you get (rpm -q now also shows the arch).

[sparkybarkalot]

@scott: you're right because...
@breun: i ran your suggestion and got this output:

mysql-5.0.27-1.fc6.art.x86_64
mysql-5.0.27-1.fc6.i386

So my uneducated guess is that i386 version isn't doing anything for me and I can uninstall it. Am I missing something by thinking that? So then my next question would be: how do I uninstall JUST the i386 version via yum? Forgive me if this is a basic question... just haven't found the answer elsewhere.

[breun]

Code: Select all

yum remove mysql.i386

[sparkybarkalot]

Perfect. Once I removed mysql.i386 I was able to update the x86__64 MySQL. Thanks scott and breun.