بکاپ و ریستور MySQL داخل Docker و Docker Compose

services:
  db:
    image: mysql:8.4
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
      MYSQL_DATABASE: appdb
    volumes:
      - mysql_data:/var/lib/mysql
    ports:
      - "127.0.0.1:3306:3306"
volumes:
  mysql_data:

docker compose exec -T db sh -c 'exec mysqldump -uroot -p"$MYSQL_ROOT_PASSWORD" \
  --single-transaction --routines --events --no-tablespaces appdb' \
  | gzip > appdb_$(date +%F_%H-%M).sql.gz

docker exec mysql-container sh -c 'exec mysqldump -uroot -p"$MYSQL_ROOT_PASSWORD" --single-transaction appdb' \
  > appdb.sql

docker compose stop db
docker run --rm -v mysql_data:/data -v $(pwd):/backup alpine \
  tar czf /backup/mysql_data_$(date +%F).tgz -C /data .
docker compose start db

#!/usr/bin/env bash
set -euo pipefail
cd /opt/myapp
OUT=/var/backups/mysql/appdb_$(date +%F_%H-%M).sql.gz
docker compose exec -T db sh -c 'exec mysqldump -uroot -p"$MYSQL_ROOT_PASSWORD" --single-transaction --routines --events --no-tablespaces appdb' | gzip > "$OUT"
find /var/backups/mysql -name 'appdb_*.sql.gz' -mtime +14 -delete

# crontab -e :
# 0 3 * * * /usr/local/bin/mysql-docker-backup.sh >> /var/log/mysql-backup.log 2>&1