#!/bin/sh
# Daily database backup (VPS + Docker). Keeps 14 days locally. Also copy the folder off the server.
set -e
cd "$(dirname "$0")/.."
mkdir -p backups
docker compose exec -T db sh -c 'mariadb-dump -u root -p"$MARIADB_ROOT_PASSWORD" --single-transaction anish24' | gzip > "backups/anish24-$(date +%F-%H%M).sql.gz"
find backups -name 'anish24-*.sql.gz' -mtime +14 -delete
echo "Backup done"