hosted by liquidweb


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

Hosting Security and Technology Configuring and optimizing web hosting servers and operating systems, developing administration scripts, building servers, protecting against hackers, and general security (SSL certificates, etc.)
Forum Jump

Anyway to downrage Mysql 5 to Mysql4.0 ?

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 08-21-2006, 06:34 AM
justbenice justbenice is offline
Web Hosting Guru
 
Join Date: Feb 2004
Posts: 322

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.

Reply With Quote


Sponsored Links
  #2  
Old 08-21-2006, 06:40 AM
rghf rghf is offline
Web Hosting Master
 
Join Date: Jun 2003
Location: UK
Posts: 6,566
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

__________________
Rus Foster - Managing Director
VPS.net - Cloud Hosting At Its Finest -21 locations and growing!
VPNHQ - Come get yourself a lovely VPN

Reply With Quote
  #3  
Old 08-21-2006, 08:09 AM
zupanm zupanm is offline
Web Hosting Master
 
Join Date: Dec 2001
Location: NYC, NY
Posts: 798
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

__________________
Blog your life away
http://photoblog.com

Reply With Quote
Sponsored Links
  #4  
Old 08-21-2006, 08:27 AM
justbenice justbenice is offline
Web Hosting Guru
 
Join Date: Feb 2004
Posts: 322
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

Reply With Quote
  #5  
Old 08-21-2006, 08:35 AM
zupanm zupanm is offline
Web Hosting Master
 
Join Date: Dec 2001
Location: NYC, NY
Posts: 798
well you have to recompile php to re-link against the mysql4 libraries

__________________
Blog your life away
http://photoblog.com

Reply With Quote
  #6  
Old 08-23-2006, 11:53 AM
justbenice justbenice is offline
Web Hosting Guru
 
Join Date: Feb 2004
Posts: 322
Thanks, i will try it .

Reply With Quote
  #7  
Old 08-23-2006, 01:57 PM
justbenice justbenice is offline
Web Hosting Guru
 
Join Date: Feb 2004
Posts: 322
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.

Reply With Quote
  #8  
Old 08-23-2006, 03:51 PM
zupanm zupanm is offline
Web Hosting Master
 
Join Date: Dec 2001
Location: NYC, NY
Posts: 798
seems to me that is still the php5 rpm?

__________________
Blog your life away
http://photoblog.com

Reply With Quote
  #9  
Old 08-23-2006, 03:53 PM
timdorr timdorr is offline
Formerly orange-y
 
Join Date: Nov 2001
Location: Atlanta, GA
Posts: 632
Quote:
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?

__________________
Former owner of A Small Orange
New owner of <COMING SOON>

Reply With Quote
  #10  
Old 08-23-2006, 05:27 PM
cywkevin cywkevin is offline
Predatory Poster
 
Join Date: Jul 2003
Location: Goleta, CA
Posts: 5,550
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?

Reply With Quote
Reply

Related posts from TheWhir.com
Title Type Date Posted
Web Host Rackspace Launches Private Beta for MySQL Cloud Database Web Hosting News 2011-12-01 21:09:51
Parallels Now Offering Licenses for CloudLinux OS Web Hosting News 2011-10-26 17:29:25
Web Hosting Sales and Promos Roundup - October 7, 2011 Web Hosting News 2011-10-07 19:56:18
Web Hosting Software Firm CloudLinux Releases CloudLinux OS Version 6.1 Web Hosting News 2011-09-13 14:08:49
Web Host FireHost Partners with Cloud Security Firm Gazzang for Data Encryption Web Hosting News 2011-08-16 20:33:43


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?