Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Urgent help reqd Downgrading from MySQL5 to MySQL4

Discussion in 'General Discussion' started by mydomain, May 27, 2006.

  1. mydomain

    mydomain Well-Known Member

    Joined:
    Aug 10, 2003
    Messages:
    138
    Likes Received:
    0
    Trophy Points:
    166
    Hello,

    Had too many issues after upgrading to mySQL5 and now need to revert back to mySQL4.

    Please could anyone confirm the best way to do this, any help greatly appreciated. The server contains a lot of sites, it is not a new server.

    TIA
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 mydomain, May 27, 2006
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    Did you upgrade MySQL manualy, or through the WHM? There is an option in the WHM >> "Tweak Setting" to downgrade to v4.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 AndyReed, May 27, 2006
  3. mydomain

    mydomain Well-Known Member

    Joined:
    Aug 10, 2003
    Messages:
    138
    Likes Received:
    0
    Trophy Points:
    166
    There isnt an option to downgrade once you go up to version 5 Andy, only if you force cpanel to believe that a lower version is installed by editing /var/cpanel/cpanel.config can you then see the lower version in tweak settings

    We edited the file to show 4.1, then ran /scripts/mysqlup again to get 4.1 on there again

    After this we ran buildapache, a mysqlcheck and everything is back to 4.1 now
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 mydomain, May 27, 2006
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    You didn't say what version of the cPanel/WHM you're using. FYI, the option is in WHM 10.8.0 cPanel 10.8.2 E117.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 AndyReed, May 27, 2006
  5. dyrer

    dyrer Active Member

    Joined:
    Jun 3, 2005
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    156
    cPanel Access Level:
    Website Owner
    I have upgraded to 4.1 but now in tweak setting there isn't 4.0 anymore
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 dyrer, May 28, 2006
  6. monsta

    monsta Member

    Joined:
    Jun 23, 2003
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    New Orleans
    Tweak Settings

    If you want to roll back to 4.0, go into /var/cpanel/cpanel.config and put the MYSQL version to 4. This will give you three options through WHM 5.0 4.1 4.0. Then run mysqlup and you should be golden with whatever version you have defined in the /var/cpanel/cpanel.config or you can update via WHM.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 monsta, May 28, 2006
  7. mohit

    mohit Well-Known Member

    Joined:
    Jul 12, 2005
    Messages:
    553
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Sticky On Internet
    hi,
    I've a server migration pending, my old server has MYSQL 4.0.25 and new one has 4.1
    could any expert show some light will it cause any issues due to this version difference.

    see ya,
    mohit
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 mohit, May 28, 2006
  8. monsta

    monsta Member

    Joined:
    Jun 23, 2003
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    New Orleans
    Migration

    What version of Apache are you running? What version of PHP are you running? What version of MYSQL are you using? What version of *nix are you using. These are all things you want to answer to yourself and research the forums before you do the update. If your unsure of what you are doing but still want to go for it, then make sure that you back up all your DBs. Good luck and post if you have any problems. With all the postings on this forum, it really helped my troubleshooting. Thanks guys and girls.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 monsta, May 28, 2006
  9. festprint

    festprint Member

    Joined:
    Nov 3, 2003
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    151
    See http://forums.cpanel.net/showthread.php?t=53554 that's the problem you may (or may not having) worth a look!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 festprint, May 29, 2006
    Last edited: Oct 21, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - Urgent help reqd
  1. segun_nira

    Urgent need to Recover mistakenly deleted files

    segun_nira, Jul 24, 2017, in forum: E-mail Discussion
    Replies:
    7
    Views:
    794
    24x7server
    Jul 25, 2017
  2. cPanelBenny

    Urgent DCV Updates

    cPanelBenny, Jul 10, 2017, in forum: cPanel Announcements
    Replies:
    3
    Views:
    4,997
    linux4me2
    Jul 20, 2017
  3. phil99

    SOLVED Help with CSF custom regex

    phil99, Jun 10, 2018, in forum: Security
    Replies:
    10
    Views:
    108
    cPanelLauren
    Jun 11, 2018
  4. Spork Schivago

    Need help Setting up more than one DMARC record.

    Spork Schivago, Apr 29, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    8
    Views:
    150
    Spork Schivago
    May 4, 2018
  5. xyourxhighnessx

    Need help with CSV/file manager.

    xyourxhighnessx, Apr 20, 2018, in forum: General Discussion
    Replies:
    4
    Views:
    114
    cPanelLauren
    Apr 20, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice