#!/bin/bash
##Program: This script will be executed at a known time to create a database duplicate and upload it to another host.
#Contact:http://www.ninthday.net
#
##
# 定义数据库的信息，其中Name为数据库名，Username为数据库用户名，Password为密码 #
Name=ninthday_sql
Username=ninthday_sql
Password=ninthday_passwd
# 定义本地备份路径 #
Localdir=/home/chroot/home/ninthday
# 定义本地备份的临时名称 #
LBackname=backup-blog-$(date +%Y%m%d).sql
# 定义本地三天前备份的名称 #
LOldbackup=backup-blog-$(date -d -3day +%Y%m%d).sql.tar.gz
# 定义远程备份名称 #
RBackname=backup-blog-$(date +%Y%m%d).sql.tar.gz
# 定义远程5天前备份名称 #
ROldbackup=backup-blog-$(date -d -5day +%Y%m%d).sql.tar.gz
# 定义远端FTP信息 #
FTPHost=216.18.217.23
FTPName=ninthday_ftp
FTPPasswd=ninthday_passwd
# 定义发送和接收通知邮件的地址(须在不同的域) #
sender=root@ninthday.net
receiver=****@126.com
# 开始创建本地文件 #
/usr/local/mysql/binmysqldump -u$Username -p$Password $Name > $Localdir/backups/$LBackname
# 压缩至本地 #
tar zPcf $Localdir/backups/$RBackname $Localdir/backups/$LBackname
#  上传数据 #
lftp $FTPHost -u $FTPName,$FTPPasswd << EOF
cd backups
mput $Localdir/backups/$RBackname
mrm $ROldbackup
bye
EOF
# 删除本地多余及过期数据 #
rm -f $Localdir/backups/$LBackname
if [ -e $Localdir/backups/$LOldbackup ] ; then
    rm -f $Localdir/backups/$LOldbackup
fi
# 写日志文件 #
echo "A datebase duplicate has been created and uploaded to the host on $(date +%F)." >> $Localdir/logs/dbbackup.log
# 发送通知邮件 #
sendmail -t <<EOF
From: Host <$sender>
To:  $receiver
Subject: Database succeeded in creating backup.
----------------------------------------------------------
The VPS has succeeded in creating and uploading database duplicate.
It holds 5 database duplicates created on the latest 5 sequential days
on remote host and 3 database's backups on localhost(/backups/).
Please download the backup files to your computer on a regular time schedule.
Don't reply this email!
Contact: harid@ninthday.net
http://www.ninthday.net
----------------------------------------------------------
EOF
exit 0