Backup Script

Backup Script

#!/bin/bash

DATE="$(date +%Y%m%d)"

log="/var/log/backups.log"
echo "" >> $log
/bin/date >> $log
echo "---------------------------------------------" >> $log
echo "DB Backup" >> $log
echo "" >> $log

DBNAME=""
DBHOST=""
DBPASS=""
DBUSER=""

echo ">> Backup: $DBNAME" >> $log

mysqldump -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME --single-transaction | gzip > "/root/backups/$DATE-$DBNAME.sql.gz"

find /root/backups -type f -name '*.sql.gz' -mtime +10 -exec rm {} \;