How to Upgrade MySQL on cPanel Server
The easiest methods to upgrade MySQL to MySQL5.5 on cPanel server
You can upgrade your server’s MySQL version with WHM’s “MySQL Upgrade” interface, which is located at:
Home >> Software >> MySQL Upgrade.
Or please follow the steps to upgrade it from commandline
Check MySQL version
mysql -V mysql Ver 14.14 Distrib 5.1.73, for unknown-linux-gnu (x86_64) using readline 5.1
First stop MySQL and backup MySQL folder so that you can use it if anything goes wrong
Stop MySQL
/etc/init.d/mysql stop
Copy /var/lib/mysql Directory
cp -rf /var/lib/mysql /home/MySQL_backup/
Also take a MySQL dump of all databases
mysqldump --all-databases > All_db_backup.sql
Now edit the file
vi /var/cpanel/cpanel.config
Change
mysql-version=5.1 to mysql-version=5.5
Now Run
/scripts/check_cpanel_rpms --fix
No do an easy Apache to install any missing modules
/scripts/easyapache --force
Monthly server support with Unlimited tickets, 24×7 monitoring, Security Audit and lot more for just $59
Leave A Comment