#!/usr/bin/env bash
set -euo pipefail

STAMP=$(date +%Y%m%d_%H%M%S)
BACKUP_DIR="${BACKUP_DIR:-/home/CPANEL_USER/backups/afya360}"
mkdir -p "$BACKUP_DIR"

mysqldump \
  --user="${DB_USERNAME:-root}" \
  --password="${DB_PASSWORD:-}" \
  --host="${DB_HOST:-127.0.0.1}" \
  --result-file="$BACKUP_DIR/afya360-$STAMP.sql" \
  "${DB_DATABASE:-afya360}"

echo "Backup saved to $BACKUP_DIR/afya360-$STAMP.sql"
