whm (mysql5 to mysql4 ??)

Portal Home > Knowledgebase > Articles Database > whm (mysql5 to mysql4 ??)

Posted by xserverx, 11-17-2007, 06:42 PM
in whm tweak setting I have changed mysql ver4.0 to mysql ver5.0 with mistake when I want to make restore of mysql ver 4.0 in tweak setting I dont find the radio button to select mysql ver 0.4 how to fix this please and retorn to vr 0.4 again ??
Posted by creaws, 11-17-2007, 09:37 PM
Upgrading to mysql 5 is a one-time convertion thing in terms of data, if you didnt make a backup before is not an easy one except that you still have not databases. Is that is the case you can change the parametre "mysql-version" of these files /usr/local/cpanel/etc/cpanel.config /var/cpanel/cpanel.config And then run: /scripts/mysqlup -- force from console. I recommend doing a back up of the entire /var/lib/mysql before playing with mysql upgrades. Regards
Posted by Skylar MacMinn, 11-17-2007, 09:45 PM
My suggestion would be to leave it as it is. Most companies will no longer give support to MySQL4 in the near future, and will get outdated. Seeing as you would potentially lose data in the downgrade, you'd be better of staying with MySQL5, unless it creates massive issues for your sites.
Posted by david510, 11-17-2007, 10:20 PM
No need to edit the file /usr/local/cpanel/etc/cpanel.config. Only the other file is checked while upgrades and tweak settings. To make it mysql 4.0 add the following line. mysql-version=4
Posted by xserverx, 11-18-2007, 06:23 AM
you are geat man your solution is perfict