downgrading MySQL to 4.0, is it possible?

[myBox]

Hi,

I have just took a new server that came with cpanel latest version.

WHM 10.8.0 cPanel 10.8.2-R73
CentOS 4.3 i686 - WHM X v3.1.0

it came by default with MySQL 4.1.18

the server is currenlty empty.

I went to tweak settings to change the version to 4.0 but the option is not there. you can only choose version 5.0 or 4.1!

how can I downgrade without disrubting cpanel normal setup.

Is it possibvle to just install the original mysql RPM?

will there be any side effects?

I searched the forums but all posts regarding upgrade issues. I want to downgrade.

thank you.

[webignition]

10.8.1-STABLE_114 gives the option of 4.1 or 4.0.

Therefore downgrading to 10.8.1-S_114 might do the trick as in it should give you the option of 4.1 or 4.0, however since 10.8.2-R_73 are quite different, I doubt the downgrade would go smoothly.

[AndyReed]

10.8.1-STABLE_114 gives the option of 4.1 or 4.0.

Therefore downgrading to 10.8.1-S_114 might do the trick as in it should give you the option of 4.1 or 4.0, however since 10.8.2-R_73 are quite different, I doubt the downgrade would go smoothly.

Permit me to add that you need to backup your MySQL DBs, just in case.

[myBox]

10.8.1-STABLE_114 gives the option of 4.1 or 4.0.

Therefore downgrading to 10.8.1-S_114 might do the trick as in it should give you the option of 4.1 or 4.0, however since 10.8.2-R_73 are quite different, I doubt the downgrade would go smoothly.

thank you for your hint it helped me alot even though the down grade was not so smooth.


I have to rename /var/lib/mysql to something else because it was nto starting up.

then it worked.

then I had to change mysql root password and again run:
/scripts/mysqlup --force

you may want to run it a couple of times just to make sure.

then of course you need to check other databases like modsec and leachprotect. (defaults)
maybe uninstall them and then install them back.

I am lucky because I did not have any production databases (brand new server).

but what if you have production databases?

I think you should first export all the databases using --compat=mysql4 option then reimport them in to mysql v4.0 database server after you install it, am I right?

thank you.