#!/usr/bin/env bash # Back up WordPress: the database, wp-content (uploads, themes, plugins), # wp-config.php and .env, into ~/wordpress/backups/. Keeps the 7 newest. set -euo pipefail umask 077 cd "$(dirname "$(readlink -f "$0")")" keep=7 mkdir -p backups out="backups/wordpress-$(date -u +%Y%m%d-%H%M%S).tar.gz" work=$(mktemp -d) trap 'rm -rf "$work"' EXIT docker compose exec -T db sh -c 'MYSQL_PWD="$MARIADB_ROOT_PASSWORD" exec mariadb-dump -uroot \ --single-transaction --routines --triggers --hex-blob --default-character-set=utf8mb4 \ wordpress' > "$work/wordpress.sql" tail -n 1 "$work/wordpress.sql" | grep -q '^-- Dump completed' || { echo "database dump incomplete" >&2; exit 1; } tar -czf "$out.part" --exclude=html/wp-content/cache --exclude='html/wp-content/upgrade*' \ -C "$work" wordpress.sql -C "$PWD" .env compose.yaml php.ini exe-dev \ html/wp-config.php html/.htaccess html/wp-content mv "$out.part" "$out" ls -1 backups/wordpress-*.tar.gz | head -n -"$keep" | xargs -r rm -- echo "$out"