Results 1 to 10 of 10
  1. #1
    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.

  2. #2
    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

  3. #3
    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.sql
    Blog your life away
    http://photoblog.com

  4. #4
    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

  5. #5
    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

  6. #6
    Join Date
    Feb 2004
    Posts
    329
    Thanks, i will try it .

  7. #7
    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.

  8. #8
    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

  9. #9
    Join Date
    Nov 2001
    Location
    Atlanta, GA
    Posts
    633
    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>

  10. #10
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •