#!/bin/bash
PATH=$PATH:/usr/local/sbin:/usr/bin:/bin
export PATH
#
filename=db
cd /home/backup/mysql
mkdir $filename$(date +%Y%m%d)
databases=(mysql test)
for dbname in ${databases[*]}
do
/usr/local/mysql/bin/mysqlhotcopy -u root -p ****** $dbname /home/backup/mysql/$filename$(date +%Y%m%d)
echo $(date +'%Y-%m-%d %H:%M:%S')" Database:$dbname backup success!" >> /usr/local/mysql/MySQLBackup.log
done
cd /home/backup/mysql/
tar -zcvf $filename$(date +%Y%m%d).tar.gz $filename$(date +%Y%m%d)
rm -rf $filename$(date +%Y%m%d)
## overdue time is 7 days
rm -rf $filename$(date +%Y%m%d --date='7 days ago').tar.gz
echo "The file 7 days ago : "$filename$(date +%Y%m%d --date='7 days ago').tar.gz" has been successfully deleted!" >> /usr/local/mysql/MySQLBackup.log