Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Anyway to downrage Mysql 5 to Mysql4.0 ?

[justbenice]

Hi
I am running a server with directadmin , centos 64bit, apache2, php5, mysql5 and i got some big problem with mysql5.0 so i need to downgrade to mysql 4.0 ( Need 4.0 because it dont have collation ) . I'v tried to rpms -e all of mysql 5 pakage and install mysql 4 rpms but it doesnt work. Anyone know how to do it ?
Thank you.
Ken.

[rghf]

I don't think you can go back as the SQL tables are compatible. If you don't have any data you want then I would suggest a reload

[zupanm]

you can dump all databases in mysql 4.0

mysqldump -u root -p --compatible=mysql40 --all-databases > file.sql


then you remove 5.0 and probably need to get rid of the DB dir.. but to be safe i'd just move the like /var/lib/mysql to /var/lib/mysql.OLD just in case instead of removing it.. install 4.0 and re-import the dump

mysql -u root < file.sql

[justbenice]

hi, I'v tried it but it doesnt' complete remove Mysql5. I still see mysql client 5 in phpinfo . And when i instasll mysql4 it doesn't start up.
About a database,i have database backup in mysql 4.0 so it doesn't matter about a compatible

[zupanm]

well you have to recompile php to re-link against the mysql4 libraries

[justbenice]

Thanks, i will try it .

[justbenice]

Ok,i recompile php and when i start apache i got this :
Cannot load /usr/lib/apache/libphp5.so into server: libmysqlclient.so.15: cannot open shared object file: No such file or directory

What should i do now ? Mysql4.0 i install from rpms.

[zupanm]

seems to me that is still the php5 rpm?

[timdorr]

Originally Posted by justbenice

Ok,i recompile php and when i start apache i got this :
Cannot load /usr/lib/apache/libphp5.so into server: libmysqlclient.so.15: cannot open shared object file: No such file or directory

What should i do now ? Mysql4.0 i install from rpms.

Did you install the client RPMs as well as the server RPMS? Did you recompile PHP?

[cywkevin]

Make sure you get the client devel and server mysql rpms.