本文共 1318 字，大约阅读时间需要 4 分钟。

#!/bin/bash host="目标ip" id="用户名" pwd="密码" dbs=$(echo "show databases;" | mysql -u$id -p$pwd -h$host) nodeldb="Database information_schema performance_schema test mysql" backuppath="/root/mysqlbackup" day=15 localIp=$(/sbin/ifconfig -a|grep inet|grep -v 127.0.0.1|grep -v inet6|awk '{print $2}'|tr -d addr:地址:) [ ! -d $backuppath ] &&mkdir -p $backuppath cd $backuppath backupname=mysql_$(date +%Y-%m-%d) for db in $dbs; do    isbool="0"    for nodb in $nodeldb;    do     if [ "$db" == "$nodb" ]     then         isbool="1"         fi     done    if [ "$isbool" == "1" ]    then       continue    fi    mysqldump -u$id -p$pwd -h$host $db >$backupname_$db.sql    echo "$db"    if [ "$?" == "0" ]    then        echo $(date +%Y-%m-%d)" $localIp $host $db  mysqldump sucess">>mysql.log    else       echo $(date +%Y-%m-%d)"  $localIp $host $db mysql dump failed">>mysql.log       echo $(date +%Y-%m-%d)" client $localIp backup $host $db is Failure"       exit 0    fi done tar -czf $backupname.tar.gz *.sql #上一句执行的返回值linux中0表示成功 if [ "$?" == "0" ] then    echo $(date +%Y-%m-%d)" tar sucess">>mysql.log   else    echo $(date +%Y-%m-%d)" tar failed">>mysql.log    echo $(date +%Y-%m-%d)" client $localIp backup and Compression service $host is Failure"    exit 0 fi rm -f *.sql delname=mysql_$(date -d "$day day ago" +%Y-%m-%d).tar.gz rm -f $delname echo $(date +%Y-%m-%d)"  $localIp backup  $host is success" |mail 18790542086@163.com

转载地址：https://blog.csdn.net/weixin_33093437/article/details/114726181 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！