[toc]
docker mysql 定时备份
参考如下：
- https://blog.csdn.net/qq_32688731/article/details/102910199
- https://www.cnblogs.com/longxing520/archive/2020/10/13/13807712.html
创建 sheel文件
#!/bin/bash
docker exec -it mysql mysqldump -uroot -proot test > "/usr/local/test/mysql/backup/data_`date +%Y%m%d`.sql"
send=`date '+%Y-%m-%d %H:%M:%S'`
if [ $? -ne 0 ];
then
# 任务失败，发送邮件
echo "$send 任务失败，发送邮件"
exit -1
else
echo "$send 数据备份成功！"
fi
crontab -e 创建linux任务计划
# 每天下午16点02分执行
17 17 * * * sh /usr/local/hsmj/test_dump.sh > /usr/local/test/mysql/backup/mysql_dumps.log 2>&1