Urgent help reqd Downgrading from MySQL5 to MySQL4

mydomain

Well-Known Member
Aug 10, 2003
138
0
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
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,217
4
193
Minneapolis, MN
mydomain said:
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.
Did you upgrade MySQL manualy, or through the WHM? There is an option in the WHM >> "Tweak Setting" to downgrade to v4.
 

mydomain

Well-Known Member
Aug 10, 2003
138
0
166
AndyReed said:
Did you upgrade MySQL manualy, or through the WHM? There is an option in the WHM >> "Tweak Setting" to downgrade to v4.
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
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,217
4
193
Minneapolis, MN
mydomain said:
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
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.
 

monsta

Member
Jun 23, 2003
11
0
151
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.
 

mohit

Well-Known Member
Jul 12, 2005
553
0
166
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
 

monsta

Member
Jun 23, 2003
11
0
151
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.
 

festprint

Member
Nov 3, 2003
10
0
151
mydomain said:
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
See http://forums.cpanel.net/showthread.php?t=53554 that's the problem you may (or may not having) worth a look!
 
Last edited: