使用定时任务执行MySQL数据库备份

备份数据库的脚本 

#!/bin/bash

USER=root
PASSWD=123456
DBNAME=testdb
FORMAT_DATE=$(date +%Y-%m-%d-%H-%M)
NAME_FILE=${DBNAME}-${FORMAT_DATE}

(docker exec -it mysql mysqldump -u${USER} -p${PASSWD} ${DBNAME} > /root/sql_bak/backup/${NAME_FILE}) &> /dev/null


[ -f /root/sql_bak/backup/${NAME_FILE} ]

if [ $? -eq 0 ];then
    (tar zcf /root/sql_bak/backup/${NAME_FILE}.tar.gz /root/sql_bak/backup/${NAME_FILE} ) &>/dev/null
    rm -f  /root/sql_bak/backup/${NAME_FILE}
    echo "${FORMAT_DATE} Successs" >> /root/sql_bak/log/${DBNAME}.log
else
   echo "${FORMAT_DATE} Fail" >> /root/sql_bak/log/${DBNAME}.log
fi

远程备份数据库

#!/bin/bash

USER=root
PASSWD=123456
DBNAME=testdb
FORMAT_DATE=$(date +%Y-%m-%d-%H-%M)
NAME_FILE=${DBNAME}-${FORMAT_DATE}

(docker exec -it mysql mysqldump -u${USER} -p${PASSWD} -h 192.168.1.100 ${DBNAME} > /root/sql_bak/backup/${NAME_FILE}) &> /dev/null


[ -f /root/sql_bak/backup/${NAME_FILE} ]

if [ $? -eq 0 ];then
    (tar zcf /root/sql_bak/backup/${NAME_FILE}.tar.gz /root/sql_bak/backup/${NAME_FILE} ) &>/dev/null
    rm -f  /root/sql_bak/backup/${NAME_FILE}
    echo "${FORMAT_DATE} Successs" >> /root/sql_bak/log/${DBNAME}.log
else
   echo "${FORMAT_DATE} Fail" >> /root/sql_bak/log/${DBNAME}.log
fi

添加到定时任务

crontab -e

0 0 * * * cd /root/sql_bak/; /bin/bash ./start.sh