#!/bin/bash
# Backup DB + tarball vtemessiniegori prima di upgrade 26.
#   sudo bash /var/www/html/server-ops/mypantarei/backup-vtemessiniegori-pre2604.sh

set -euo pipefail

VTE=/var/www/html/vtemessiniegori
STAMP=$(date +%Y%m%d-%H%M)
DEST="${BACKUP_DIR:-/var/www/html/_backups}"
mkdir -p "$DEST"

readarray -t DB_VARS < <(php8.3 -r "
chdir('${VTE}');
require 'config.inc.php';
echo (\$dbconfig['db_name'] ?? '') . PHP_EOL;
echo (\$dbconfig['db_username'] ?? '') . PHP_EOL;
echo (\$dbconfig['db_password'] ?? '') . PHP_EOL;
")

DB_NAME="${DB_VARS[0]}"
DB_USER="${DB_VARS[1]}"
DB_PASS="${DB_VARS[2]}"

SQL="${DEST}/vtemessiniegori-${STAMP}.sql"
TGZ="${DEST}/vtemessiniegori-files-${STAMP}.tgz"

echo "Dump DB ${DB_NAME} -> ${SQL}"
MYSQL_PWD="$DB_PASS" mysqldump -u "$DB_USER" --single-transaction --routines --triggers "$DB_NAME" > "$SQL"

echo "Tarball -> ${TGZ}"
tar czf "$TGZ" -C /var/www/html vtemessiniegori \
	--exclude='vtemessiniegori/cache' \
	--exclude='vtemessiniegori/storage' \
	--exclude='vtemessiniegori/vte_updater/3001' \
	2>/dev/null || tar czf "$TGZ" -C /var/www/html vtemessiniegori

ls -lh "$SQL" "$TGZ"
echo "Backup completato."