Updating from Mysql 4.0 to 4.1

[helpline]

There is no option to upgrade from Mysql 4.0 to 4.1 in WHM.

Please advise.. how this can be done reliably .... also.. what are the risks associated?

[yapluka]

What is your WHM version ? You should find the upgrade option in "Tweak Settings".

[madan.cpanelnet]

Steps to upgrade to mysql 4.1 using WHM:
--------------------------------------------------
Edit /var/cpanel/cpanel.config file and set

mysql-version=4.1
usemysqloldpass=1

/scripts/mysqlup
/scripts/perlinstaller --force Bundle::BD::mysql
/scripts/easyapache

Next, change mysqlroot password via WHM.




Steps to upgrade to mysql 4.1 using rpm:
----------------------------------------------

MySQL 4.1 rpms
###############
wget http://mysql.sd2.mirrors.redwire.net....21-0.i386.rpm
wget http://mysql.sd2.mirrors.redwire.net....21-1.i386.rpm
wget http://mysql.sd2.mirrors.redwire.net....21-0.i386.rpm
wget http://mysql.sd2.mirrors.redwire.net....21-0.i386.rpm
wget http://mysql.sd2.mirrors.redwire.net....21-0.i386.rpm
wget http://mysql.sd2.mirrors.redwire.net....21-0.i386.rpm
wget http://mysql.sd2.mirrors.redwire.net....21-0.i386.rpm

root@server11 [~/mysql-4.1.21-rpms]# rpm -Uvh MySQL*.rpm
root@server11 [~]# /scripts/perlinstaller --force Bundle:BD::mysql
root@server11 [~]# /scripts/easyapache

Next, change mysqlroot password via WHM.