#!/usr/bin/env bash
set -euo pipefail
: "${DB_HOST:?Set DB_HOST}"
: "${DB_PORT:=3306}"
: "${DB_DATABASE:?Set DB_DATABASE}"
: "${DB_USERNAME:?Set DB_USERNAME}"
: "${DB_PASSWORD:?Set DB_PASSWORD}"
: "${BACKUP_DIR:=/var/backups/ojodu-hmis}"
mkdir -p "$BACKUP_DIR"
chmod 700 "$BACKUP_DIR"
STAMP="$(date -u +%Y%m%dT%H%M%SZ)"
umask 077
MYSQL_PWD="$DB_PASSWORD" mysqldump --host="$DB_HOST" --port="$DB_PORT" --user="$DB_USERNAME" --single-transaction --routines --triggers "$DB_DATABASE" | gzip > "$BACKUP_DIR/${DB_DATABASE}_${STAMP}.sql.gz"
unset MYSQL_PWD
find "$BACKUP_DIR" -type f -name '*.sql.gz' -mtime +30 -delete
echo "Backup created: $BACKUP_DIR/${DB_DATABASE}_${STAMP}.sql.gz"
