Downgrade MySQL 5.0 to 4.1.x?

Sykoi

Member
Oct 19, 2004
24
0
151
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?
 

loverboy

Active Member
May 1, 2005
31
0
156
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
 

jayh38

Well-Known Member
Mar 3, 2006
1,213
0
166
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.
 

loverboy

Active Member
May 1, 2005
31
0
156
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
 

jayh38

Well-Known Member
Mar 3, 2006
1,213
0
166
Sykoi said:
Thanks, but will setting the version to 4 update to 4.0.27 or 4.1?
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.
 

Sykoi

Member
Oct 19, 2004
24
0
151
Even though I plan on backing up, what are the chances something will go wrong, and what exactly can go wrong?
 

jayh38

Well-Known Member
Mar 3, 2006
1,213
0
166
Permissions and password issues. I never ran into anything overly complicated.
 

Sykoi

Member
Oct 19, 2004
24
0
151
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?
 

jayh38

Well-Known Member
Mar 3, 2006
1,213
0
166
Try recreating the database from the version 5 backup. It should convert
over nicely.
 

Sykoi

Member
Oct 19, 2004
24
0
151
jayh38 said:
Try recreating the database from the version 5 backup. It should convert
over nicely.
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?


db.table
error : Table './db/table was created with a different version of MySQL and cannot be read