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.

Downgrade MySQL 5.0 to 4.1.x?

Discussion in 'General Discussion' started by Sykoi, Sep 8, 2006.

  1. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    I recently updated my MySQL from 4.0.23 (Severely out of date) to 5.0, and I'm really regretting it, as it has broken quite a few things (Forums mainly).
    Is there an easy, safe way to downgrade without losing data or screwing anything up even more?
     
  2. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Anyone? Please?
     
  3. loverboy

    loverboy Active Member

    Joined:
    May 1, 2005
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    yes iam one

    but i need to know how to Downgrade from 4.1.xx and 5.xx to 4.0.27 again like you :D

    if any one replay you please tell me ;)

    good luck
     
  4. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    I should not have to tell you to make a backup of mysql and user accounts prior to any upgrade or downgrade. If my advise was needed, Then I would highly suggest hiring someone experienced to perform this for you.

    edit the config file and change version to 4
    /var/cpanel/cpanel.config and set mysql-version=4

    Then force a mysql update
    /scripts/mysqlup --force


    You may then have to recreate accounts or some other adjustments.

    Good luck.
     
  5. loverboy

    loverboy Active Member

    Joined:
    May 1, 2005
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    good luck Sykoi you got the matter in the same day :D


    jayh38 thanks very much for your excellent help ;)

    see you in another post :D
     
  6. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Thanks, but will setting the version to 4 update to 4.0.27 or 4.1?
     
  7. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    You should get the very earliest 4.0 available.

    You can do this without initiating any changes.
    Set the version to 4 as described in the earlier post.

    Then look in the tweak settings in WHM and you will then see the available mysql versions.

    4.0, 4.1 and 5 should be the available options.
     
  8. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Even though I plan on backing up, what are the chances something will go wrong, and what exactly can go wrong?
     
  9. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Permissions and password issues. I never ran into anything overly complicated.
     
  10. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Err, I thought I had made a thread about this but I guess it got deleted....

    I downgraded from 5.0 to 4.1, but now theres a few tables that aren't working and are constantly LOCKED... How do I fix this?
     
  11. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Anyone...? Kind of important
     
  12. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Try recreating the database from the version 5 backup. It should convert
    over nicely.
     
  13. Sykoi

    Sykoi Member

    Joined:
    Oct 19, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Errr... What version 5 backup? And also, just thought I'd mention:
    I created the db/tables in 4.0.27, upgraded to 5.0 a few weeks later, and it only started to not work when I downgraded to 4.1....
    Is there any way to get this to work, just locally upgrade this database from 4.0.27 to 4.1?


     
Loading...

Share This Page