#!/usr/bin/env bash
# BlueStack LLC - Automated MySQL/MariaDB Daily Backup Script
# Add to crontab: 0 3 * * * /usr/local/bin/a1-mysql-backup-cron.sh
set -euo pipefail

BACKUP_DIR="/backups/mysql"
DB_NAME="your_database_name"
DB_USER="root"
RETENTION_DAYS=7
DATE=$(date +%Y-%m-%d_%H%M)

mkdir -p "$BACKUP_DIR"
mysqldump -u "$DB_USER" --single-transaction --quick "$DB_NAME" | gzip > "${BACKUP_DIR}/${DB_NAME}_${DATE}.sql.gz"
find "$BACKUP_DIR" -type f -name "*.sql.gz" -mtime +"$RETENTION_DAYS" -delete

echo "[$(date)] Backup completed: ${BACKUP_DIR}/${DB_NAME}_${DATE}.sql.gz"
