mySQL Upgrade from 3.23 to 4.0
 

I am bit confused. I thought that I should go to Package Manager and remove the mySQL 3.23 which I did. However, if I then search for all files mysql*, it looks like there are still dozens of mysql files even after it said it was removed. Why?

Is it safe now to install the new version? Is there anything I will need to do beyond installing the new RPMs to get it working with PHP?

Thanks

Not really, you could install the MySQL 4.0 binaries. Just be sure you have BACKUPED your databases before. If I remember correctly the MySQL user table, etc got modified so be sure that you do NOT overwrite this with your old MySQL 3.23 mysql database or you might run into problems ...

This is what I was concerned about when I was looking at the 4.0 upgrade. BTW, I have never used mySQL before and thus don't have any databases that I am concerned about at this time in terms of backing up.

"Ensure that you don't have any MySQL clients that uses shared libraries (like the Perl DBD-mysql). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed. The same applies for Python MySQLdb."

When I tried

[root@sforsgren-linux-01 mySQL 4.1]# rpm -e mysql-3.23.56-1.9
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-5
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3

So, this seemed to imply that if I install 4.0, I have to revisit all of these other products that will no longer work due to the change in libmysqlclient.so.10, right?

How do I get upgraded to 4.0 and still ensure that all of these other packages still work?

Thanks!

I have exactly the same problem - watching for your success with anticipation !

You might try the latest version 4.0.13 installing the
MySQL-compat-4.0.13 rpm. instead of using the share rpm.
The compat rpm is to resolve this issue.
www.mysql.com/doc/en/Linux-RPM.html

1. /etc/rc.d/init.d/mysqld stop

2. rpm -e perl-DBD-Mysql mysql-3.23 mysql-devel mysql-server qt-Mysql Mysql-python
php-mysql perl-DBI.rpm

( We remove modules with which we have dependency problem in libmysqlclient..so.10 )

3. rpm -ivh Mysql-4.0.17.rpm Mysql-server-4.0.17.rpm Mysql-client.rpm Mysql-devel.rpm


4. /etc/rc.d/init.d/mysql start

5. mysql -v
(shows that version 4.0.17 is installed)

Avirup Dasgupta

I forgot to mention that u must also install Mysql-shared-compat-4.0.17.i386.rpm at step 3.

#rpm -ivh Mysql-4.0.17.rpm Mysql-server-4.0.17.rpm Mysql-client-4.0.17.rpm Mysql-devel-4.0.17.rpm Mysql-shared-compat-4.0.17.i386.rpm



Avirup Dasgupta