Vahid
August 6th, 2008, 01:22
Howto: Upgrade Cpanel To Latest Mysql
Sometime the folks from cpanel are behind in updating some software packages. Here is the lazyman's way of upgrading. It's all automatic you just need to chmod the file and let it run, once it's completed just update your root password of mysql.
Step 1
SSH into your box.
Step 2 - Open the file for editing
nano mysql.sh
Step 3 - Copy the following code into your window.
Code:
################################
# CPANEL MYSQL UPGRADER #
# SCRIPT COPYRIGHT MYACEN.COM #
################################
###### UPGRADE PERL-DBI ######
up2date -fp perl-DBI
###### Stop The SQL ######
service mysql stop
###### Stop Chkservd ######
service chkservd stop
####### Create a tmp dir ######
mkdir /usr/local/src/mysqlup
###### Change to tmp dir ######
cd /usr/local/src/mysqlup
###### Download Mysql ######
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-server-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-bench-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-client-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-devel-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-shared-4.1.18-0.i386.rpm)
####### Extract Mysql ######
rpm -Uvh MySQL-*.rpm
####### Restart SQL ######
service mysql start
###### Restrar Chkservd ######
service chkservd start
###### Disable Cpanel Automysql updates ######
touch /etc/mysqlupdisable
####### Clean Unwanted Files ######
rm -rf /usr/local/src/mysqlup
Step 4 - Chmod the file
chmod 755 mysql.sh
Step 5 - Run the file
./mysql.sh
Step 6 - Change root password
Once this has finished change the mysql root password.
We are testing on mysql5 at the moment. We've installed this on 30 servers with no problems. This is not supported by us and we recommend you backing up any database's before trying this (although as I said we have not had any problems)
Sometime the folks from cpanel are behind in updating some software packages. Here is the lazyman's way of upgrading. It's all automatic you just need to chmod the file and let it run, once it's completed just update your root password of mysql.
Step 1
SSH into your box.
Step 2 - Open the file for editing
nano mysql.sh
Step 3 - Copy the following code into your window.
Code:
################################
# CPANEL MYSQL UPGRADER #
# SCRIPT COPYRIGHT MYACEN.COM #
################################
###### UPGRADE PERL-DBI ######
up2date -fp perl-DBI
###### Stop The SQL ######
service mysql stop
###### Stop Chkservd ######
service chkservd stop
####### Create a tmp dir ######
mkdir /usr/local/src/mysqlup
###### Change to tmp dir ######
cd /usr/local/src/mysqlup
###### Download Mysql ######
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-server-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-bench-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-client-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-devel-4.1.18-0.i386.rpm)
wget File Not Found (http://mysql.he.net/Downloads/MySQL-4.1/MySQL-shared-4.1.18-0.i386.rpm)
####### Extract Mysql ######
rpm -Uvh MySQL-*.rpm
####### Restart SQL ######
service mysql start
###### Restrar Chkservd ######
service chkservd start
###### Disable Cpanel Automysql updates ######
touch /etc/mysqlupdisable
####### Clean Unwanted Files ######
rm -rf /usr/local/src/mysqlup
Step 4 - Chmod the file
chmod 755 mysql.sh
Step 5 - Run the file
./mysql.sh
Step 6 - Change root password
Once this has finished change the mysql root password.
We are testing on mysql5 at the moment. We've installed this on 30 servers with no problems. This is not supported by us and we recommend you backing up any database's before trying this (although as I said we have not had any problems)