一个好用的mysql备份脚本

#!/bin/bash
#edit by www.jb200.com
DBUser=backup
DBPasswd="123456"
DBHost=192.168.8.112
DBName=`echo "select SCHEMA_NAME from information_schema.SCHEMATA where schema_name not in ('information_schema','test');" | mysql -h$DBHost -u$DBUser -p$DBPasswd --skip-column-names --silent`
BackupPath=/data/data_store
LogFile=/data/data_store/log/mysql_backup.log
NewFile=$(date +%Y%m%d).tgz
OldFile=$(date +%Y%m%d --date='7 days ago').tgz

pushd $BackupPath >> $LogFile
echo $OldFile
echo "----------" >> $LogFile
echo $(date +"%Y-%m-%d %H:%M:%S") >> $LogFile
echo "----------" >> $LogFile
#Delete Old File
if [ -f $OldFile ]
then
     rm -f $OldFile >> $LogFile 2>&1
     echo "[$OldFile]Delete Old File Success!" >> $LogFile
else
     echo "[$OldFile]No Old Backup File!" >> $LogFile
fi

#backup mysql
if [ -f $NewFile ]
then
   echo "[$NewFile]The Backup File is exists,Can't Backup!" >> $LogFile
else
   for item in $DBName
   do
      DumpFile=$item".sql"
      mysqldump -h$DBHost -u$DBUser -p$DBPasswd -R --triggers --single-transaction --flush-logs --master-data --database $item > $DumpFile
   done
   /bin/tar czvf $NewFile *.sql >> $LogFile 2>&1
   /bin/rm -f *.sql
fi
echo "--------" >> $LogFile
popd >> $LogFile

#crontab -e
0 1 * * * /bin/bash /data/data_store/mysql_backup