Sh备份数据库 sh脚本备份数据库#!/bin/bash BACKUP=/u01/backup/MySQL/ DATETIME=$(date '+%Y-%m-%d') DB_HOST=127.0.0.1 DB_USER=root DB_PWD=root DATABASE1=test DATABASE2=test_api mkdir -p "${BACKUP}/$DATETIME" TIME=$(date '+%H%M%S') mysqldump -u${DB_USER} -p${DB_PWD} -h${DB_HOST} -q -R --databases $DATABASE1 | gzip > ${BACKUP}/$DATETIME/${TIME}_${DATABASE1}.sql.gz mysqldump -u${DB_USER} -p${DB_PWD} -h${DB_HOST} -q -R --databases $DATABASE2 | gzip > ${BACKUP}/$DATETIME/${TIME}_${DATABASE2}.sql.gzcrontab定时任务语法可以参考这个网站https://toolhut.cn/tools/crontab