一步一个脚印的完善，简单到复杂

auto_backup_mysql_v1.sh

#!/bin/bash
#2020年7月7日 16:45:07
#by author linzc
#auto backup mysql database
###############################
SQL_DB="test"
SQL_USR="backup"
SQL_PWD="123456"
SQL_HOST="192.168.68.136"
SQL_CMD="/usr/local/mysql/bin/mysqldump"
BAK_DIR="/data/sh"
$SQL_CMD -h$SQL_HOST -u$SQL_USR -p$SQL_PWD $SQL_DB >$BAK_DIR/test.sql
if [ $? -eq 0 ];thenecho "the mysql databse $SQL_DB backup successfully"
elseecho "the mysql database $SQL_DB backup failed."
fi

auto_backup_mysql_v2.sh

#!/bin/bash
#2020年7月7日 17:28:28
#by author linzc
#auto backup mysql database
###############################
SQL_DB="$1"
SQL_USR="backup"
SQL_PWD="123456"
SQL_HOST="192.168.68.136"
SQL_CMD="/usr/local/mysql/bin/mysqldump"
BAK_DIR="/data/bakup"if [ $# -eq 0 ];thenecho -e "\033[32m----------------\033[0m"echo "请输入要备份的数据库"echo -e "\033[32mUsage:{/bin/bash $0 jfedu001|jfedu002|help}\033[0m"exit
fiif [ $UID -ne 0 ];thenecho "exec backup scripts,must to be user root"exit
fi
if [ ! -d $BAK_DIR ];thenmkdir -p $BAK_DIR
fi$SQL_CMD -h$SQL_HOST -u$SQL_USR -p$SQL_PWD $SQL_DB >$BAK_DIR/${SQL_DB}.sql
if [ $? -eq 0 ];thenecho -e "\033[32m----------------\033[0m"echo "the mysql databse $SQL_DB backup successfully"echo "ls -l $BAK_DIR"ls -l $BAK_DIR
elseecho "the mysql database $SQL_DB backup failed."
fi

auto_backup_mysql_v3.sh

#!/bin/bash
#2020年7月7日 17:28:28
#by author linzc
#auto backup mysql database
###############################
SQL_DB="$*"
SQL_USR="backup"
SQL_PWD="123456"
SQL_HOST="192.168.68.136"
SQL_CMD="/usr/local/mysql/bin"
SQL_CMD1="$SQL_CMD/mysql"
SQL_CMD2="$SQL_CMD/mysqldump"
BAK_DIR="/data/bakup"if [ $# -eq 0 ];thenecho -e "\033[32m----------------\033[0m"echo "请输入要备份的数据库,如果备份全部，请输入all"echo -e "\033[32mUsage:{/bin/bash $0 jfedu001|jfedu002|all|help}\033[0m"exit
fiif [ $UID -ne 0 ];thenecho "exec backup scripts,must to be user root"exit
fi
if [ ! -d $BAK_DIR ];thenmkdir -p $BAK_DIR
fiif [ "$SQL_DB" == all ];then$SQL_CMD2 -h$SQL_HOST -u$SQL_USR -p$SQL_PWD -A >$BAK_DIR/${SQL_DB}$(date +%F).sqlif [ $? -eq 0 ];thenecho -e "\033[32m----------------\033[0m"echo "the mysql databse $SQL_DB backup successfully"echo "ls -l $BAK_DIR"ls -l $BAK_DIRelseecho "the mysql database $SQL_DB backup failed."fi
elif [ ! "$SQL_DB" == all -a $# -ne 0 ];then$SQL_CMD1 -h$SQL_HOST -u$SQL_USR -p$SQL_PWD -e "show databases;" > db.txtsed -i "1d" db.txtfor DB in $SQL_DBdocat db.txt | grep $DBif [ $? -eq 0 ];then$SQL_CMD2 -h$SQL_HOST -u$SQL_USR -p$SQL_PWD $DB >$BAK_DIR/${DB}$(date +%F).sqlecho -e "\033[32m----------------\033[0m"echo "the mysql databse $DB backup successfully"elseecho "the mysql database $DB backup failed,not exist"fidoneecho "ls -l $BAK_DIR"ls -l $BAK_DIR
fi