Issues upgrading MySQL from 4.1 to 5.0 on RHEL4 - RPM trouble

[Davis, Jared S.]

I uninstalled the 4.1 RPMs and installed the 5.0 RPMs:
MySQL-client-community-5.0.89-0.rhel4.i386.rpm
MySQL-shared-community-5.0.89-0.rhel4.i386.rpm
MySQL-server-community-5.0.89-0.rhel4.i386.rpm

Everything seemed to install ok.

mysql> status outputs:
Server version: 5.0.89-community MySQL Community Edition (GPL)

However, I mistakingly installed "MySQL-shared-community-5.0.89-0.rhel4.i386.rpm" when I really needed "MySQL-shared-compat-5.0.89-0.rhel4.i386.rpm" in order for it to work correctly.*

When I try to install "MySQL-shared-compat-5.0.89-0.rhel4.i386.rpm" I get the following:

$ sudo rpm -ivh MySQL-shared-compat-5.0.89-0.rhel4.i386.rpm
warning: MySQL-shared-compat-5.0.89-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
file /usr/lib/libmysqlclient.so.15.0.0 from install of MySQL-shared-compat-5.0.89-0.rhel4 conflicts with file from package MySQL-shared-community-5.0.89-0.rhel4
file /usr/lib/libmysqlclient_r.so.15.0.0 from install of MySQL-shared-compat-5.0.89-0.rhel4 conflicts with file from package MySQL-shared-community-5.0.89-0.rhel4

So, I tried to uninstall "MySQL-shared-community-5.0.89-0.rhel4.i386.rpm", but I get the following:

$ sudo rpm -e MySQL-shared-community-5.0.89-0.rhel4.i386.rpm
error: package MySQL-shared-community-5.0.89-0.rhel4.i386.rpm is not installed

So, the RPMs are installed, but not recognized by the RPM utility? Is there a way to manually uninstall the RPMs?



*As a side note, here is why I need shared-compat (apparently), as I cannot start Apache without disabling the php5_module (or it complains about the MySQL library):

>It's the same old story, Red Hat puts the shared libraries into the same package as the
client applications instead of separing these into a "mysql-shared" and "mysql-client"
subpackage. As you are trying to update to MySQL 5.0, this would break the shared library
dependencies of the installed applications that were linked against the default MySQL 4.1
from Red Hat (as your package would update the installed "mysql" RPM to a newer version,
thus updating to newer version of the shared libs, too).
>
>To work around this, we provide the "shared-compat" RPM, that you can get from the
Downloads section. It contains the 4.1 shared libraries as well, which will fulfil this
dependency.

http://bugs.mysql.com/bug.php?id=17035