mysql镜像配置怎么设置自动备份_mysql镜像配置定时自动备份设置教程

<font face="Courier New,Courier,monospace">#!/bin/bash
# 备份目录
BACKUP_DIR=/opt/mysql_backups
# 数据库连接信息
MYSQL_HOST=localhost
MYSQL_USER=root
MYSQL_PASS=your_root_password
# 备份文件名格式：backup_2025-04-05.sql
DATE=$(date +%Y-%m-%d_%H-%M-%S)
BACKUP_FILE=$BACKUP_DIR/backup_$DATE.sql
<h1>创建备份目录</h1><p>mkdir -p $BACKUP_DIR</p><h1>使用 mysqldump 执行备份（假设 MySQL 容器名为 mysql-container）</h1><p>docker exec mysql-container mysqldump -u$MYSQL_USER -p$MYSQL_PASS --all-databases > $BACKUP_FILE</p><h1>检查是否备份成功</h1><p>if [ $? -eq 0 ]; then
echo "Backup successful: $BACKUP_FILE"
else
echo "Backup failed!"
fi</p><h1>可选：只保留最近7天的备份</h1><p>find $BACKUP<em>DIR -name "backup</em>*.sql" -mtime +7 -delete
</font>

<font face="Courier New,Courier,monospace">chmod +x /opt/mysql_backup.sh</font>

<font face="Courier New,Courier,monospace">crontab -e</font>

<font face="Courier New,Courier,monospace">0 2 * * * /opt/mysql_backup.sh >> /var/log/mysql_backup.log 2>&1</font>

<font face="Courier New,Courier,monospace">docker exec mysql-container which mysqldump</font>

<font face="Courier New,Courier,monospace">docker run -d \
  --name mysql-container \
  -e MYSQL_ROOT_PASSWORD=your_root_password \
  -v /opt/mysql_data:/var/lib/mysql \
  -v /opt/mysql_backups:/backups \
  -p 3306:3306 \
  mysql:8.0</font>

<font face="Courier New,Courier,monospace">/opt/mysql_backup.sh</font>