创建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
分 时 周 日 月