2.1 用shell脚本实现自动备份MySQL数据库

创建shell脚本文件

vim /mysql/data/shell/auto_backup_mysql.sh

文件里添加内容如下

#/bin/bash
#auto bakcup mysql db
#by authors wugk 2019
#definie backup path

BAK_DIR=/data/backup/`date +%Y%m%d`
MySQLDB=firstdb
MySQLUSR=first
MySQLPW=123
MySQLCMD=/usr/bin/mysqldump
if [ $UID -ne  0 ];then
        echo "Must to be use root for exce Shell."
        exit
fi


if [ ! -d $BAK_DIR ];then
        mkdir -p $BAK_DIR
        echo "\033[32mThe $BAK_DIR Create Successfully!\033[0m"
else
        echo "This $BAK_DIR is exists..."
fi

#MySQL BACKUP COMMAND
$MySQLCMD -u$MySQLUSR -p$MySQLPW -d $MySQLDB >$BAK_DIR/$MySQLDB.sql


if [ $? -eq 0 ];then
        echo -e "\033[32mThe MySQL Backup $MySQLDB Successfully!\033[0m"
else
        echo -e "\033[32mThe MySQL Backup $MySQLDB Failed,Please check!\033[0m"
fi

检查脚本文件是否正常

sh -n auto_backup_mysql.sh

令脚本每天0点运行

crontab -e

在里面编辑内容如下

0   0 * * * /bin/bash /data/shell/auto_backup_mysql.sh >>/tmp/mysql_bak.log 2>&1

这里解释一下上一段代码中每个星号的意思

*  *  *  *  * /bin/bash /data/shell/auto_backup_mysql.sh
分 时 周 日  月