自动备份Mysql数据库脚本

#!/bin/bash
#2021年03月12日08:55:05
#auto backup mysql database
#by author chenshubin
########################
DB_NAME="$*"
DB_PORT=3380
DB_USR="test_db"
DB_PASS="fCrCzIa7w6JkeMjrHucg"
DB_CMD="/usr/bin/mysqldump"
DB_BAK="/data/backup/`date +%F`"
if [ $# -eq 0 ];then
    echo -e "\033[32m---------------------------------\033[0m"
    echo -e "\033[32mUsage:{/bin/sh $0 DB01|DB02|help}\033[0m"
    exit 1
fi
if [ ! -d $DB_BAK ];then
    mkdir -p $DB_BAK
fi

for i in $(echo $DB_NAME|sed 's/ /\n/g'|sort -nr)
do
    if [ $i == "all" ];then
            $DB_CMD -P$DB_PORT -u$DB_USR -p$DB_PASS --all-databases >$DB_BAK/all.sql
    else
        $DB_CMD -P$DB_PORT -u$DB_USR -p$DB_PASS $i >$DB_BAK/${i}.sql
    fi        

    if [ $? -eq 0 ];then
                echo -e "\033[32m----------------------\033[0m" >> $DB_BAK/baksql.log
                echo -e "\033[32mThe $i backup success.\033[0m" >> $DB_BAK/baksql.log
        else
                echo -e "\033[32m---------------------------------\033[0m" >> $DB_BAK/baksql.log
                echo -e "\033[32mThe $i backup failed.please exit.\033[0m" >> $DB_BAK/baksql.log
                exit 2
        fi
done

##压缩
cd /data/backup
tar jcvf `date +%F`.tar.bz2 `date +%F`
if [ $? -eq 0 ];then
    echo -e "\033[32mThe `date +%F` tar success.\033[0m" >> tarsql.log
    rm -rf $DB_BAK
else
    echo -e "\033[32mThe `date +%F` tar failed.\033[0m" >> tarsql.log
fi

##删除N天前的历史备份
find /data/backup/ -maxdepth 1 -type f -name "*.tar.bz2" -mtime +7 -exec rm -f {} \;