Updated MySQL

[Nessy]

I recently updated mysql to 5.0.18-standard but then some of my php scripts dont work so i wanted to put it back to version 4.4.2 but it wont let me do it through whm is there any other way to do it

[madaboutlinux]

If you wish to downgrade Mysql to 4.x, you can do that from Tweak Settings in WHM. Sometimes upgrading from WHM will not show the lower version of Mysql in WHM. In that case you will have to edit the file /var/cpanel/cpanel.config

But make sure you take the backup of your databases before you downgrade or you will be in trouble.

Also the same issue has been recently discussed few times. Search the forums for more help.

Paste any errors you receive.

[parkypoo22]

Did you recompile apache after your upgrade?

[Nessy]

Did you recompile apache after your upgrade?

yeah i did

[Nessy]

If you wish to downgrade Mysql to 4.x, you can do that from Tweak Settings in WHM. Sometimes upgrading from WHM will not show the lower version of Mysql in WHM. In that case you will have to edit the file /var/cpanel/cpanel.config

But make sure you take the backup of your databases before you downgrade or you will be in trouble.

Also the same issue has been recently discussed few times. Search the forums for more help.

Paste any errors you receive.

Hello There

i tried to edit that file, but it was still set to 4.1.1 but in whm it is set to 5.0.18-standard. Do you have any other ideas

[madaboutlinux]

As you say the version in your cpanel.config file is 4.1.1, have you tried /scripts/mysqlup --force ?

If you still face the same problem, you will either have to manually downgrade Mysql to whatever version you wish to downgrade or I will suggest you to ask someone to login to your server and get it check for you.