The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

downgrading MySQL to 4.0, is it possible?

Discussion in 'General Discussion' started by myBox, May 5, 2006.

  1. myBox

    myBox Active Member

    Joined:
    Jan 6, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    I have just took a new server that came with cpanel latest version.

    WHM 10.8.0 cPanel 10.8.2-R73
    CentOS 4.3 i686 - WHM X v3.1.0

    it came by default with MySQL 4.1.18

    the server is currenlty empty.

    I went to tweak settings to change the version to 4.0 but the option is not there. you can only choose version 5.0 or 4.1!

    how can I downgrade without disrubting cpanel normal setup.

    Is it possibvle to just install the original mysql RPM?

    will there be any side effects?

    I searched the forums but all posts regarding upgrade issues. I want to downgrade.

    thank you.
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    10.8.1-STABLE_114 gives the option of 4.1 or 4.0.

    Therefore downgrading to 10.8.1-S_114 might do the trick as in it should give you the option of 4.1 or 4.0, however since 10.8.2-R_73 are quite different, I doubt the downgrade would go smoothly.
     
  3. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Permit me to add that you need to backup your MySQL DBs, just in case.
     
  4. myBox

    myBox Active Member

    Joined:
    Jan 6, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6

    thank you for your hint it helped me alot even though the down grade was not so smooth.


    I have to rename /var/lib/mysql to something else because it was nto starting up.

    then it worked.

    then I had to change mysql root password and again run:
    /scripts/mysqlup --force

    you may want to run it a couple of times just to make sure.

    then of course you need to check other databases like modsec and leachprotect. (defaults)
    maybe uninstall them and then install them back.

    I am lucky because I did not have any production databases (brand new server).

    but what if you have production databases?

    I think you should first export all the databases using --compat=mysql4 option then reimport them in to mysql v4.0 database server after you install it, am I right?

    thank you.
     
Loading...

Share This Page