Hi Guys...

I using Fedora Core and recently tried to upgrade MySQL v3.23 to MySQL ver 4.1.16

I first un-installed the previous MySQL version comletely. While doing this, Since it was warning me about certain applications that were depending upon MySQL 3.23 , i like a fool un-installed those applications as well before proceeding. I don't think i un-installed anything of major importance except php-mysql. Following is from my command history while i was doing this

826 rpm -qa |grep sql
827 rpm -e mysql-server-3.23.58-4
828 rpm -e mysql-3.23.58-4
829 rpm -e php-mysql-4.3.8-1.1
830 rpm mod_auth_mysql-20030510-3
831 rpm -e mod_auth_mysql-20030510-3
832 rpm -qa |grep sql
833 rpm -e mysql-3.23.58-4
834 rpm -e perl-DBD-MySQL-2.9002-1
835 rpm -e mysql-3.23.58-4
836 man rpm
837 rpm -e --nodeps mysql-3.23.58-4
838 rpm -e perl-DBD-MySQL-2.9002-1


Now i installed mysql 4.1.16 and to ensure everything goes smoothly, pretty much installed all there was to install

I used rpm -ivh *My*

MySQL-bench-4.1.16-1.glibc23.i386.rpm MySQL-ndb-management-4.1.16-1.glibc23.i386.rpm
MySQL-client-4.1.16-1.glibc23.i386.rpm MySQL-ndb-storage-4.1.16-1.glibc23.i386.rpm
MySQL-debuginfo-4.1.16-1.glibc23.i386.rpm MySQL-ndb-tools-4.1.16-1.glibc23.i386.rpm
MySQL-devel-4.1.16-1.glibc23.i386.rpm MySQL-server-4.1.16-1.glibc23.i386.rpm
MySQL-embedded-4.1.16-1.glibc23.i386.rpm MySQL-shared-4.1.16-1.glibc23.i386.rpm
MySQL-Max-4.1.16-1.glibc23.i386.rpm
MySQL-ndb-extra-4.1.16-1.glibc23.i386.rpm



So now MySQL and php are working fine independantly. However, since i un-installed php-mysql-4.3.8-1.1 , i think php does not have mysql support.

I tried to re-install php-mysql using yum , but it gives a dependancy error -:
Resolving dependencies
....identical dependency loop exceeded
package php-mysql needs libmysqlclient.so.10 (not provided)

I did a search for this on my machine and got the following -:

[root@development root]# locate sqlclient
/usr/lib/mysql/libmysqlclient.a
/usr/lib/mysql/libmysqlclient.la
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient_r.la
/usr/lib/debug/usr/lib/libmysqlclient_r.so.14.0.0.debug
/usr/lib/debug/usr/lib/libmysqlclient.so.14.0.0.debug
/usr/lib/libmysqlclient.so.14
/usr/lib/libmysqlclient.so
/usr/lib/libmysqlclient.so.14.0.0
/usr/lib/libmysqlclient_r.so
/usr/lib/libmysqlclient_r.so.14
/usr/lib/libmysqlclient_r.so.14.0.0

How do i make php work with mysql now...please help.

install the shared-compat package and you should be golden. FYI if you install the shared-compat package you don't need to install the shared library package as the shared-compat package installs the libraries from the shared library package as well as the *.so.10 library. Also, you won't have any dependency issues with programs you've installed - you won't have to uninstall stuff like you did at first.

thanks...it worked...

ok...i am gonna repeat the same procedure on an identical ... this time live server.

As per your suggestions, i will not un-install anything other than mysql-server 3.23 .

Then i will look for an installed mysql-shared ... if there is any, i will first un-install this....then install mysql-compat and then install mysql v 4.1.16

am i correct ?

I would uninstall any installed mysql-shared package, and then upgrade everything in one go (including the mysql-shared-compat package). But this is because I use an rpm distro where I can use the -U flag.

If you're going from version 3.X to 4.X and greater, you better read the upgrading notes on mysql's website. There's quite a few things that are not compatible between versions.