#!/bin/bash
# Aether MariaDB Backup Script (Physical Backup)
set -e

PROJECT_ROOT="/home/scott/OSIT_dev/aether_container_env"
BACKUP_DIR="${PROJECT_ROOT}/backups"
TIMESTAMP=$(date +%Y%m%d_%H%M)
BACKUP_FILE="${BACKUP_DIR}/local_backup_${TIMESTAMP}.gz"

echo "--- Starting Aether Local Database Backup ---"
mkdir -p "${BACKUP_DIR}"

# Increased open-files-limit to prevent OS error 24
echo ">>> Backing up to ${BACKUP_FILE}..."
docker exec ae_mariadb_dev mariabackup --user=root --password='$1sky.AE_dev.2023' \
    --backup --stream=xbstream --open-files-limit=65535 | gzip > "${BACKUP_FILE}"

echo "--- Backup Complete! ---"
ls -lh "${BACKUP_FILE}"