MySQL Backup Script for Cpanel Server

#!/bin/bash
# by Sileep Kumar M S <sileepkumar@gmail.com>

#Todays date in ISO-8601 format:
DAY0=`date -I`
#6 days ago in ISO-8601 format (to keep 30days backup)
DAY6=`date -I -d "6 days ago"`
#Backup Directory
DIR=/home/MYSQL_BACKUPS

rm -rf $DIR/$DAY6


if [ -d $DIR ]; then

    mkdir $DIR/$DAY0
    for DB in `mysql -e 'show databases'|awk '{print $1}'`;
    do mysqldump $DB |gzip > $DIR/$DAY0/$DB.sql.gz;
    done

else

    mkdir $DIR
    mkdir $DIR/$DAY0
    for DB in `mysql -e 'show databases'|awk '{print $1}'`;
    do mysqldump $DB |gzip > $DIR/$DAY0/$DB.sql.gz;
    done

fi  

Popular posts from this blog

MySQL table conversion

To convert all InnoDB Tables to MyISAM (all databases) SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'InnoDB'; To convert all MyISAM Tables to InnoDB (all databases) SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=InnoDB;') FROM information_schema.TABLES WHERE ENGINE = 'MyISAM'; Run the single command from the provided list of commands got from the above result to convert the tables
Read more

Add addon-domain, sundomain and parked domains via shell in a Cpanel server

For Subdomain and Addon domains echo "[UID] ADD [SUB] [DOMAIN] [TURN OFF CAN NAME] [DIR]" | /usr/local/cpanel/bin/ domainadmin [UID] = unix uid of user to add domain to [SUB] = subdomain portion of the domain ==>bob<===. cpanel.net [DOMAIN] non sub portion bob.==> cpanel.net <== [TURN OFF CAN NAME] = 0 for subdomains, 1 for addon domains [DIR] = /home/USER/public_html/bob For Parked domains echo "[UID] ADD [DOMAIN] [TOPDOMAIN]" | /usr/local/cpanel/bin/ parkadmin [UID] = unix uid of user to add domain to [DOMAIN] = parked domain [TOPDOMAIN] = domain to park on  
Read more

Cpanel Migration Script

#!/bin/bash #Script Usage:  sh migration.sh <user> <source_IP> #by Sileep Kumar M S <sileepkumar@gmail.com> USER=$1 IP=$2 PORT=22 if [ -z "$USER" ] | [ -z "$IP" ]; then     echo "Usage: sh migration.sh <user> <source_IP>" else /usr/bin/ssh -p $PORT -o StrictHostKeyChecking=no root@$IP "/bin/mkdir /home/MIGRATION" echo "Packing the account $USER" /usr/bin/ssh -p $PORT -o StrictHostKeyChecking=no root@$IP "/usr/local/cpanel/bin/pkgacct --skiphomedir $USER /home/MIGRATION" echo "Downloading the package from $IP" /bin/rm -f /home/cpmove-$USER.tar.gz  /usr/bin/scp -P $PORT root@$IP:/home/MIGRATION/ cpmove-$USER.tar.gz /home/ echo "Restoring the account $USER"   if [ -f /home/cpmove-$USER.tar.gz ]; then   /usr/local/cpanel/bin/ restorepkg --force $USER   else   echo "/home/cpmove-$USER.tar.gz not found"   fi echo "C...
Read more