#!/bin/bash
now=$(date +'%Y%m%d')
echo "SELECT DATEDIFF($now, date) FROM customers WHERE bckp_plan = 0;" | mysql -uUSERNAME -pPASSWORD -D DATABASE-N | while read -r difference;
do
if [ $difference -gt 0 ];
then
echo "SELECT customers.username, db_name FROM mysql_databases INNER JOIN customers ON mysql_databases.cust_id=customers.cust_id WHERE customers.bckp_plan = 0;" | mysql -uUSERNAME -pPASSWORD -D DATABASE-N | while read -r username db_name;
do
if [ ! -d  /etc/backups/$username ]; then
mkdir /etc/backups/$username
fi
mysqldump -uUSERNAME -pPASSWORD $db_name > /etc/backups/$username/$db_name.sql
done
echo "SELECT username FROM customers WHERE bckp_plan = 0;" | mysql -uUSERNAME -pPASSWORD -D DATABASE -N | while read -r username;
do
cp -R /var/www/$username /etc/backups/$username/
tar -czf /etc/backups/$username.tar.gz -C /etc/backups/$username $username
rsync -avzhe ssh /etc/backups/$username.tar.gz USER@DOMAIN:~/backups/
done
rm -rf /etc/backups/*
fi
done