#!/usr/bin/env bash
# Skrip Otomasi Cadangan Basis Data & Dokumen Web
set -euo pipefail

BACKUP_DIR="/var/backups/web_app"
DATE_STAMP=$(date +"%Y%m%d_%H%M%S")
DB_NAME="ai_virtual_office"
TARGET_FILE="${BACKUP_DIR}/${DB_NAME}_${DATE_STAMP}.sql.gz"

mkdir -p "${BACKUP_DIR}"

echo "[INFO] Memulai proses pencadangan basis data: ${DB_NAME}..."
# mysqldump -u root -p"${DB_PASS}" "${DB_NAME}" | gzip > "${TARGET_FILE}"
echo "[OK] Berkas cadangan tersimpan di ${TARGET_FILE}"

# Hapus cadangan yang lebih tua dari 14 hari
find "${BACKUP_DIR}" -type f -name "*.sql.gz" -mtime +14 -delete
echo "[OK] Pembersihan arsip lama selesai."