# version: 1.0 for linux
# method: 全备份mysql数据
# author: fengzhanhai
# history: create program V1.0 20121101 by fengzhanhai
# tasks: * 1 * * * /home/db-backup/mysql/mysqlbk.sh >> /dev/null 2>&1
#conf---------
UserName='sdmtv'
myPwd='sdtv@13.cm'
DbName=mms_sdmtv
BakDir=/data/tongji/
LogFile=/data/tongji/backdb.log
DATE=`date +%Y%m%d`
DumpFile=data$DATE.sql
FtpServer=10.0.211.12
FtpTargetPath=/root/mon
#main-------------
echo $(date +"%y-%m-%d %H:%M:%S") backup begin >> $LogFile
cd $BakDir
#备份当天文件
/usr/bin/mysqldump -u$UserName -p$myPwd $DbName -t > $BakDir$DumpFile
echo $(date +"%y-%m-%d %H:%M:%S") Dump Done >> $LogFile
echo $(date +"%y-%m-%d %H:%M:%S") $GZDumpFile compress done >> $LogFile
#上传到ftp服务器
ftp -v -n $FtpServer << END
user dbback1 s.allook.cn
bin
#cd $FtpTargetPath
put $DumpFile
bye
END
echo $(date +"%y-%m-%d %H:%M:%S") ftp $GZDumpFile compress done >> $LogFile
rm -f $GZDumpFile
#删除当前目录下7天前的文件备份文件
find $BakDir -name "data*" -mtime +7 -exec rm {} \;
echo $(date +"%y-%m-%d %H:%M:%S") delete old file done >> $LogFile
#验证结果
ls -al $DumpFile >> $LogFile