Downgrade MySQL 5.0 to 4.1.x?

[Sykoi]

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?

 

[Sykoi]

Anyone? Please?

 

[loverboy]

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]

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]

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

 

[Sykoi]

Thanks, but will setting the version to 4 update to 4.0.27 or 4.1?

 

[jayh38]

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]

Even though I plan on backing up, what are the chances something will go wrong, and what exactly can go wrong?

 

[jayh38]

Permissions and password issues. I never ran into anything overly complicated.

 

[Sykoi]

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?

 

[Sykoi]

Anyone...? Kind of important

 

[jayh38]

Try recreating the database from the version 5 backup. It should convert
over nicely.

 

[Sykoi]

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