wp-docker-setup/backup.sh

#! /bin/sh
#

if [ ! -f "${PWD}/.env" ]; then
  echo "missing env file in ${PWD}"
  exit 1
fi

set -a
. "${PWD}/.env"
set +a

docker compose stop

now="$(date +%Y-%m-%d_%H-%M-%S)"
backup_path="${PWD}/backup-volumes/${now}"
mkdir -p "${backup_path}"

volumes="db root traefik-dynamic traefik-certs traefik-logs traefik-static webroot"
volumes="db"
for volume in ${volumes}; do
  mkdir -p "${backup_path}/${volume}"
  docker run \
    --rm \
    --volume "${backup_path}/${volume}":/destination \
    --volume "${PREFIX}-${volume}:/${volume}" \
    ubuntu \
    tar -cvzf "/destination/${volume}.tar.gz" -C "/${volume}" .
done

docker compose restart db
docker compose restart app
while ! docker ps -q -f name="${PREFIX}-db"; do
  echo "Waiting for the db container to be up and running..."
  sleep 1
done

while ! docker exec "${PREFIX}-app" /bin/sh -c "mysqladmin ping -h ${PREFIX}-db -P 3306 --protocol=tcp -u user -puser --silent"; do
  echo "Waiting for the mysql server in the db container to be up and running and reachable from the app container..."
  sleep 1
done

mkdir -p "${backup_path}/db"
docker exec "${PREFIX}-db" \
  /usr/bin/mysqldump \
  -u root \
  --password="${DB_ROOT_PASSWORD}" \
  "${DB_NAME}" > "${backup_path}/db/${DB_NAME}.sql"

docker compose stop db
docker compose stop app