WEB CONTENT AND MYSQL BACKUP SCRIPT

#!/bin/bash

DATE=`date +%F`

COPY_TO=/backups/$DATE
COPY_FROM=/home/websites

DBBACKUPNAME=”mysql-“$DATE
WEBBACKUPNAME=”website-“$DATE
USER=root
PASSWORD=password
HOST=localhost
mkdir -p $COPY_TO

echo “”;
echo “************************************”;
echo ” DATABASES BACKUP”;
echo “************************************”;
echo “”;
date=`date -I`
for I in $(mysql -u root -ppassword -e ‘show databases’ -s –skip-column-names);
do
mysqldump -u root -ppassword $I | gzip > “$COPY_TO/$date-$I.sql.gz”;
done
echo “”;
echo “************************************”;
echo ” WEB BACKUP”;
echo “************************************”;
echo “”;
echo “Wait a moment please…”;
for x in $(find $COPY_FROM -maxdepth 1 -name “*” -type d -print0 | xargs -0)
do
tar -cpvzf $COPY_TO/$WEBBACKUPNAME-$(basename $x).tar.gz $x &> /dev/null
done;
echo “Done!”;