Tuesday 26 January 2016

MYSQL UPGRADATION 

Make sure you run all the following in a screen otherwise in case if you loose connection while upgrade process through a normal ssh session, there is possibility of breaking up things.

First and prime thing is to backup everything related to mysql prior to upgrade.

Backup /etc/my.cnf, /root/.my.cnf ,/usr/local/apache/conf/httpd.conf , libmysqlclient.so (might be in path /usr/lib64, depends on class) module , php.ini

Take all databases dumps and mysql directory backup to

After all backing up process.

1) Change mysql-version=5.1 to mysql-version=5.5 in file /var/cpanel/cpanel.config

2) Run /scripts/check_cpanel_rpms --fix

   OR

run the upcp itself /scripts/upcp --force
((before running upcp script make sure, you set CPANEL=stable in "/etc/cpupdate.conf". Importance of stable tier is, it is always provided with bug fixed cPanel version))

3) Run easyapache to recompile apache and especially php needs to be rebuilt with new mysql modules.

After successfull easyapache, you're done with mysql upgrade. Check websites randomly if there is any issue.



No comments:

Post a Comment