docker安装的mysql如何备份

脚本如下

# 设置 MySQL 登录信息
DATABASE='iot'

# 备份文件路径和名称
BACKUP_DIR='/data/backup/mysql/data'
BACKUP_FILE="$BACKUP_DIR/backup_$(date +%Y%m%d_%H%M%S).sql"
# 使用mysqldump备份数据库
docker exec mysql mysqldump --user=gkrh --password=Gkrh@67930967 --databases backstage_management discipline_inspection_iot iot nacos official_website province_backstage zhongyuan_iot   > $BACKUP_FILE
# 检查mysqldump命令是否成功执行
if [ $? -eq 0 ]; then
echo "数据库备份成功: $BACKUP_FILE"
else
echo "数据库备份失败"
fi

find $BACKUP_DIR -type f -name "backup_*.sql" -mtime +30 -exec rm {} \;
if [ $? -eq 0 ]; then
echo "旧的备份文件已成功清理"
else
echo "清理旧备份文件失败"
fi

定时任务

定时任务

1. crontab -e
2. 0 3 * * * /data/backup/mysql/backup_mysql.sh