[CentOS] corrupt rpm problem

[Peter Farrow]

Hi There,

Install Centos 4.1 X86-64 onto an athlon64 box.

unfortunately half way through a yum -y upgrade I press ctrl-c on the 
wrong window and aborted a couple of the packages in the (large) update.

Now the rpm database things there are multiple packages installed on the 
same rpm versions,

eg:
 >rpm -q -a | grep mysql
mod_auth_mysql-2.6.1-2.2
php-mysql-4.3.9-3.6
mysqlclient10-3.23.58-4.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-devel-4.1.10a-2.RHEL4.1
mysql-4.1.10a-2.RHEL4.1
mysql-4.1.10a-2.RHEL4.1
libdbi-dbd-mysql-0.6.5-10.RHEL4.1

rpm -e mysqlclient10-3.23.58-4.RHEL4.1
error: "mysqlclient10-3.23.58-4.RHEL4.1" specifies multiple packages


So I tried a "yum clean all" and tried again but yum fails with a 
transaction check error with conflicts of rpms onthemselves.

I did a rpm --rebuilddb  with no joy, and i deleted the __db files from 
/var/lib/rpm - still no joy.

I cn't install any rpms now as it says there are conflicts....

I am fresh out of ideas now...

Any help appreciated...

P.