Results 1 to 10 of 10
-
08-21-2006, 06:34 AM #1Web Hosting Guru
- Join Date
- Feb 2004
- Posts
- 329
Anyway to downrage Mysql 5 to Mysql4.0 ?
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.
-
08-21-2006, 06:40 AM #2Web Hosting Master
- Join Date
- Jun 2003
- Location
- UK
- Posts
- 6,616
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
Russ Foster - Industry Curmudgeon
Freelance Sysadmin for Hire - email vaserv@gmail.com
-
08-21-2006, 08:09 AM #3Web Hosting Master
- Join Date
- Dec 2001
- Location
- NYC, NY
- Posts
- 799
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.sqlBlog your life away
http://photoblog.com
-
08-21-2006, 08:27 AM #4Web Hosting Guru
- Join Date
- Feb 2004
- Posts
- 329
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
-
08-21-2006, 08:35 AM #5Web Hosting Master
- Join Date
- Dec 2001
- Location
- NYC, NY
- Posts
- 799
well you have to recompile php to re-link against the mysql4 libraries
Blog your life away
http://photoblog.com
-
08-23-2006, 11:53 AM #6Web Hosting Guru
- Join Date
- Feb 2004
- Posts
- 329
Thanks, i will try it .
-
08-23-2006, 01:57 PM #7Web Hosting Guru
- Join Date
- Feb 2004
- Posts
- 329
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.
-
08-23-2006, 03:51 PM #8Web Hosting Master
- Join Date
- Dec 2001
- Location
- NYC, NY
- Posts
- 799
seems to me that is still the php5 rpm?
Blog your life away
http://photoblog.com
-
08-23-2006, 03:53 PM #9Formerly orange-y
- Join Date
- Nov 2001
- Location
- Atlanta, GA
- Posts
- 633
Originally Posted by justbeniceFormer owner of A Small Orange
New owner of <COMING SOON>
-
08-23-2006, 05:27 PM #10Predatory Poster
- Join Date
- Jul 2003
- Location
- Goleta, CA
- Posts
- 5,566
Make sure you get the client devel and server mysql rpms.
Patron: I'd like my free lunch please.
Cafe Manager: Free lunch? Did you read the fine print stating it was an April Fool's joke.
Patron: I read the same way I listen, I ignore the parts I don't agree with. I'm suing you for false advertising.
Cafe Owner: Is our lawyer still working pro bono?