PHP 4.2.3 and MySQL 4.0.4

[Hilbe]

I am currently using the RPM installed version for MySQL 3.23.52 and PHP 4.2.3. I saw the other day that MySQL 4.0.4 is available in RPM format and that it can upgrade 3.23.52. My question is what issues may occur as a result? The MySQL RPM for PHP is configured for 3.23.52 I believe, but MySQL should be backwards compatible and work. Just curious if anyone has tried something similar.

[sks1024]

I've successfully upgraded MySQL on a Fedora server by following these steps:

1. Download the server, client, and "Dynamic client libraries
   (including 3.23.x libraries)" rpms.
2. rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm
3. rpm -Uvh MySQL-shared-compat-4.0.18-0.i386.rpm
4. rpm -Uvh MySQL-client-4.0.18-0.i386.rpm
5. I had to manually kill the mysqld process and restart, but after that everything works fine, including my php code.

Here is the link to download

Go to the rpm's section(second section down on the page)

http://dev.mysql.com/downloads/mysql/4.0.html