mysql 备份脚本

#!/bin/bash
date="$(date +%Y%m%d)"
year="$(date +%Y)"
month="$(date +%m)"
day="$(date +%d)"
backDir="/backup/mysql"
mysqlBin="/usr/bin/mysql"
mysqldumpBin="/usr/bin/mysqldump"
mysqlAuth="-uroot -pxxxx  -h172.xxxx -P3xxx"

############Backup DB Part#############################
echo "`date +%Y%m%d' '%T` [Info] Start Dump $DB!"
for database in `${mysqlBin} ${mysqlAuth} -s -e "show databases"`
do
        if [ "${database}" != "information_schema" ] && [ "${database}" != "performance_schema" ] && [ "${database}" != "mysql" ] && [ "${database}" != "sys" ] ; then
                mkdir -p ${backDir}/${database}/${year}/${month}
                ${mysqldumpBin} --single-transaction --master-data=2 ${mysqlAuth} ${database} | /bin/gzip > "${backDir}/${database}/${year}/${month}/${database}.${date}.gz"
        fi
done

echo "successfully"

############delete 7 date ago file####################
cd $backDir
find -name "*.gz"  -mtime +6 -exec rm  {} \;