MySQL conflicts with mysql-3.23.41-1
 

Hello,

I am running RedHat 7.2 on a dedicated server. I was attempting to upgrade a program called Plesk which uses mysql.

The Plesk upgrade installation installs/upgrades various rpms; however, when installing/upgrading the mysql rpms, the following error message:

mysql-3.23.58-1.72.i386.rpm
mysql-server-3.23.58-1.72.i386.rpm
error: failed dependencies:
MySQL conflicts with mysql-3.23.58-1.72
MySQL-server conflicts with mysql-server-3.23.58-1.72

Here is what I have installed:

MySQL-3.23.54a-2
MySQL-shared-3.23.54a-2
perl-DBD-MySQL-1.2216-4
MySQL-client-3.23.54a-2
MySQL-devel-3.23.54a-2

I quit the Plesk upgrade and decided search for tech help.

I located an article which references the same conflict/problems with non-redhat version of MySQL being installed and redhat versions being upgraded. It informed me that MySQL was a non Redhat version (redhat version is titled mysql).

Thinking I could just re-install the proper redhat version, I attempted to install mysql-3.23.58-1.72.i386.rpm but received the same error. I also attempted to install the mysql-3.23.41-1.i386.rpm from the install disk, same conflict.

I used the following commands:

rpm -U mysql-3.23.41-1.i386.rpm
rpm -Uvv mysql-3.23.41-1.i386.rpm
rpm -Uvv --force mysql-3.23.41-1.i386.rpm
rpm -Ivv --force mysql-3.23.41-1.i386.rpm

All received the same conflict message.

I decided to check my version of MySql to verify it is a non-redhat version with command: rpm -qi MySQL

Here are the results:

[root@ns temp]# rpm -qi MySQL
Name : MySQL Relocations: (not relocateable)
Version : 3.23.54a Vendor: MySQL AB
Release : 2 Build Date: Mon 23 Dec 2002 01:56:37 PM HST
Install date: Tue 27 May 2003 12:20:45 PM HST Build Host: dialtone.com
Group : Applications/Databases Source RPM: MySQL-3.23.54a-2.src.rpm
Size : 19156260 License: GPL / LGPL
Packager : Lenz Grimmer <lenz@mysql.com>
URL mysql (removed URL due to first post)
Summary : MySQL: a very fast and reliable SQL database engine
Description :
The MySQL(TM) software delivers a very fast, multi-threaded, multi-user,
and robust SQL (Structured Query Language) database server. MySQL Server
is intended for mission-critical, heavy-load production systems as well
as for embedding into mass-deployed software. MySQL is a trademark of
MySQL AB.

MY PROBLEM:

I need to install the redhat version of mysql and overwite the non-redhat versions. I also need to keep the current databases I am already using.

Any ideas as to how to re-install the redhat versions over the existing MySQL versions?

I thought of uninstalling all of mysql and re-installing the redhat version but I am new and do not know how to back-up the database files, users, etc and how to restore the all of the back-up information to the new mysql database.

Any help is greatly appreciated!! :)

Thank you in advance!