How to backup MySQL databases

Issue

When installing the DB Governor, it's highly recommended to back up all the MySQL data.

Solution

On cPanel server disable MySQL service monitoring before doing the job:

$ whmapi1 configureservice service=mysql enabled=1 monitored=0

Execute as 'root':

# 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

On cPanel server enable monitoring back:

$ whmapi1 configureservice service=mysql enabled=1 monitored=1

Note: This operation may take some time.

Useful links

CloudLinux OS Documentation - Backing up MySQL.