#!/usr/bin/env bash
# City10 database backup — run on the cloud host (cron recommended daily).
set -euo pipefail
cd "$(dirname "$0")/.."
STAMP="$(date +%Y%m%d-%H%M%S)"
mkdir -p storage/app/backups
mysqldump --single-transaction --no-tablespaces \
  -h"${DB_HOST:-127.0.0.1}" -P"${DB_PORT:-3306}" \
  -u"${DB_USERNAME}" -p"${DB_PASSWORD}" \
  "${DB_DATABASE}" | gzip > "storage/app/backups/city10-${STAMP}.sql.gz"
echo "Backup written to storage/app/backups/city10-${STAMP}.sql.gz"