Upgrade MySQL and MySQL Governor in cPanel CloudLinux based server
First make full mysql backup(including system tables) to safe location.
1) Take the backup of all the databases on the server.
$ mkdir -p ~/mysqlbkp
$ service mysql restart –skip-networking –skip-grant-tables
$ mysql_upgrade
$ mysqldump –all-databases –routines –triggers > ~/mysqlbkp/dbcopy.sql
$ service mysql stop
$ cp -r /var/lib/mysql/mysql ~/mysqlbkp/
$ service mysql start
2) update mysql/governor in the following way:
# yum update governor-mysql –enablerepo=cloudlinux-updates-testing
# /usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55
# /usr/share/lve/dbgovernor/db-select-mysql –install-now
installation completed
Note : don’t forgot to recompile php on the server.
3) MYSQL_VERSION can be one of the following:
| auto | default version of MySQL for given OS release (or cPanel settings) |
| mysql50 | MySQL v5.0 |
| mysql51 | MySQL v5.1 |
| mysql55 | MySQL v5.5 |
| mysql56 | MySQL v5.6 |
With vibrant colors, cheerful graphics, and a sprinkle of festive magic, your website can instantly create an emotional connection and…
The world of artificial intelligence is evolving faster than ever — and one of the biggest breakthroughs is here. Sora,…
Black Friday 2025 is here — the biggest shopping moment of the year, where customers expect unbeatable prices, fast performance,…
When you move or delete a page on your WordPress website, visitors — and search engines — can easily hit…
Introduction Artificial Intelligence has made remarkable strides — from writing poetry to generating code. Yet, most AIs still act like…