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 […]
See MoreTag: Mysql Backup
Backup script for reseller account
Following are the steps to take increment backup of reseller account on backup server. 1) First we need to find out the user name which is under the reseller account. On shared/source server :- vi /home/resellerUsername/backup.sh # For finding the username under the reseller account cat /etc/trueuserowners | grep resellerUsername | awk -F: ‘{print $1}’ […]
See More