Categories: CloudLinux

Upgrade MySQL and MySQL Governor in cPanel

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

 

 


Vishwajit Kale
Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.

Recent Posts

The Ultimate Guide to WordPress Maintenance: Tips and Tricks

When you’re running a business that relies on website traffic and sales to succeed. Then you need to keep it…

3 days ago

Migrate In 2024: Our Comprehensive Website Migration Manual to the Next Level

Migration! Yes, this word is very big in the web hosting industry and it has its importance. Especially for businesses…

5 days ago

Unveiling the Importance of Server Maintenance Plans: A Comprehensive Guide

The server is the backbone of the web hosting industry and it acts like a HERO in the web hosting…

2 weeks ago

IP Address is Blocked? A handpicked list of Solutions to Fix it?

Imagine you are on holiday having a cup of tea and browsing your website or blog.Then, what next?You will get…

3 weeks ago

Explained: Difference between Nameservers Vs. DNS

The web hosting industry is growing every minute, day, and year. It has many terminologies that are important to understand…

1 month ago