mysql upgrade
 

Hi,

This is probably a silly newbie question. I have a server in the sky and would like to upgrade the mysql package from version 3.x to 4.0.x

I download these files to my home directory:

MySQL-client-4.0.23-0.i386.rpm
MySQL-devel-4.0.23-0.i386.rpm
MySQL-server-4.0.23-0.i386.rpm

However, when trying the command.

rpm -Uvh MySQL-server-4.0.23-0.i386.rpm

I got the this error:

error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.10-2.4

Sorry to ask two dump questions

1) should i find / download / install the files in the error message or what? It is all confusion.

2) Should I try removing mysql-3.x.x. first?

Thanks,

james

p.s. other commands tried are:

# rpm -Uvh MySQL-devel-4.0.23-0.i386.rpm
Preparing... ########################################### [100%]
file /usr/bin/comp_err from install of MySQL-devel-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysql_config from install of MySQL-devel-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1

# rpm -Uvh MySQL-client-4.0.23-0.i386.rpm
Preparing... ########################################### [100%]
file /usr/bin/mysql from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlaccess from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlbinlog from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlcheck from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqldump from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlimport from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlshow from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysql.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqlaccess.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqladmin.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqldump.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqlshow.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqladmin from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-server-3.23.58-9.1

When I upgraded MySQL I had to remove everything that used the old 3.x version. Then I installed the new 4.1.10 version and put all of the perl/php packages back on (newer versions, of course).