mysql备份脚本--自动报警

原创

qubaoquan 2010-04-09 09:47:35 博主文章分类：mysql ©著作权

©著作权归作者所有：来自51CTO博客作者qubaoquan的原创作品，请联系作者获取转载授权，否则将追究法律责任

#!/bin/bash
BakDir=/backup/mysql/full
LogFile=/var/log/mysql-dbispconfig-backup.log
DATE=`date +%Y-%m-%d`
DumpFile=$DATE.sql
GZDumpFile=$DATE.sql.tar.gz
backup_error=/backup/mysql/backup_error
compress_error=/backup/mysql/compress_error
email1="daigh@qian-gao.com"
email2="qubq@qian-gao.com"
echo -e "\n" >>$LogFile
echo "===========> $DATE   <=============     " >>$LogFile
echo "$(date +"%H:%M:%S") begin back DNS database ">>$LogFile
cd $BakDir
mysqldump -u root -pqian-gao.com dabispconfig --default-character-set=utf8 >$DumpFile 2>/backup/mysql/backup_error
if [ $? == 0 ]
then
      echo "at $(date +"%H:%M:%S") the backup Done,now begin compress the sql file" >>$LogFile
      tar czvf $GZDumpFile $DumpFile 2>/backup/mysql/compress_error
        if [ $? == 0 ]
        then
                 echo "at $(date +"%H:%M:%S") the $GZDumpFile Backup Success!" >>$LogFile
                 echo "finish!" >>$LogFile
                 rm -f $DumpFile
        else
                 mail -s "compress_error" $email1 <$compress_error
                 mail -s "compress_error" $email2 <$compress_error