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 […]

See More

How to install MariaDB Server in cPanel/WHM servers?

How to install MariaDB Server in cPanel/WHM servers? And What are the advantages of using MariaDB Server ? Ans:  *  Install MariaDB Server in cPanel/WHM servers 1. Backup existing MySQL data # mysqldump –all-databases –routines –triggers > /home/db_dump/alldb.sql # service mysql stop # cp -r /var/lib/mysql/mysql /home/db_dump/ # service mysql start 2. Select MySQL version […]

See More

20+ Switches of rsync in Unix/Linux

* Switches of rsync: 1) -v, –verbose Increase verbosity. 2) -r, –recursive Recurse into directories. 3) -l, –links Copy symlinks as symlinks. 4) -p, –perms Preserve permissions. 5) -t, –times Preserve modification times. 6) -g, –group Preserve group. 7) -o, –owner preserve owner (super-user only) 8) -D Same as –devices –specials. –devices : preserve device files […]

See More