Anyway we can downgrade Mysql5 to Mysql4.0 ?

justbenice

Verified User
Joined
Aug 21, 2006
Messages
6
Hi
I am running a box with CentOS 64bit , Directadmin , php5,mysql5,apache2 . But i got some problem with my database which is dump from my old mysql4.0 server so i need to downgare mysql to 4.0. But even i do rpm -e all of mysql5 pakage and install new set of mysql4.0 it still doesn't work. MySQL4 doesn't load at all . :(
Anybody can help me out please ?

Regards,
Nguyen Thanh.
 
Hello,
only 3 stip :)
1) Backup all DB
Code:
/usr/bin/mysqldump --create-options --compatible=mysql40 --all-databases --force --user=root --password=123456@@ > sql.sql
2) Run MySQL script 4.1.x , test MySQL ver.

3) Restore DB

Regards,
Wael
 
Hello
Thank you for reply me, but that was not what i want . All i want are how to downgrade mysql 5 to mysql 4.0 . I'v remove all rpms pakage mysql5 and install a mysql4.0 but it doesnt' start up mysql4.0 . :(
 
justbenice said:
Hello
Thank you for reply me, but that was not what i want . All i want are how to downgrade mysql 5 to mysql 4.0 . I'v remove all rpms pakage mysql5 and install a mysql4.0 but it doesnt' start up mysql4.0 . :(
remove my.conf & start mysql again
do you build php again ?
 
Last edited:
Hi
Thank you, i'v tried to reinstall mysql4.0 again but it come with this error :
libz.so.1 is needed by MySQL-shared-4.0.26-0.i386

What should i do now ? I'v tried to install zlib but it still show that message :(
 
I also checked if libz.so.1 avaible and i already have it :
@ locate libz.so.1
/usr/lib64/libz.so.1
/usr/lib64/libz.so.1.2.1.2
/usr/local/lib/libz.so.1
/usr/local/lib/libz.so.1.2.3
 
justbenice said:
I also checked if libz.so.1 avaible and i already have it :
@ locate libz.so.1
/usr/lib64/libz.so.1
/usr/lib64/libz.so.1.2.1.2
/usr/local/lib/libz.so.1
/usr/local/lib/libz.so.1.2.3

your os 64 :eek: , i try in cento 4.3 32 work fine.
 
Hi
Ok,i am able to install mysql now , and rebuild php . After restart 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

:(
 
you need to install MySQL 4.0 64 then build php with Y then restart.

***
Cannot load /usr/lib/apache/libphp5.so
you use php 5 build php without error and all work fine.


Wael
 
mysql --user=root --password=yourpassword database < backup_file.sql
 
Is there a way to downgrade MySQL5 into MySQL 4.0?

OS: CentOS 5.2
Status: Fresh Install
Installed using Customapache

I tried using the guide from knowledgebase however it got stuck
MySQL 5.0 > 4.1 = fine
MySQL 5.0 > 4.1 > 4.0 = failed

Is it really depends the OS we are using?
 
Back
Top