使用定时任务执行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 DBNA