备份容器的数据库

使用容器备份mysql数据库

备份脚本

#!/bin/bash
BACKUP_DIR="/opt/mysql_backups"
CONTAINER_NAME="mysql-container"
DB_USER="root"
DB_PASSWORD="yourpassword"
TIMESTAMP=$(date +%Y%m%d_%H%M%S)

# 确保目录存在且可写
mkdir -p $BACKUP_DIR
chmod 777 $BACKUP_DIR

# 执行备份
docker exec $CONTAINER_NAME sh -c "mysqldump -u $DB_USER -p$DB_PASSWORD --all-databases" > $BACKUP_DIR/backup_$TIMESTAMP.sql

# 设置合适的权限（可选）
chmod 644 $BACKUP_DIR/backup_$TIMESTAMP.sql

设置脚本权限

chmod +x backup-mysql.sh
sudo chown $(whoami):$(whoami) backup-mysql.sh

# 使用容器备份mysql数据库

## 备份脚本

```bash
#!/bin/bash
BACKUP_DIR="/opt/mysql_backups"
CONTAINER_NAME="mysql-container"
DB_USER="root"
DB_PASSWORD="yourpassword"
TIMESTAMP=$(date +%Y%m%d_%H%M%S)

# 确保目录存在且可写
mkdir -p $BACKUP_DIR
chmod 777 $BACKUP_DIR

# 执行备份
docker exec $CONTAINER_NAME sh -c "mysqldump -u $DB_USER -p$DB_PASSWORD --all-databases" > $BACKUP_DIR/backup_$TIMESTAMP.sql

# 设置合适的权限（可选）
chmod 644 $BACKUP_DIR/backup_$TIMESTAMP.sql
```

## 设置脚本权限

```bash
chmod +x backup-mysql.sh
sudo chown $(whoami):$(whoami) backup-mysql.sh
```