#!/bin/bash
DB_HOST="flighth269.mysql.db"
DB_NAME="flighth269"
DB_USER="flighth269"
DB_PASS="Ec8ShJTvQHTP"

WEBROOT="$HOME/www"
BACKUP_DIR="$WEBROOT/backup_ps"
DATESTAMP=$(date +%Y-%m-%d_%Hh%M)
DEST="$BACKUP_DIR/$DATESTAMP"

mkdir -p "$DEST"

# 1. Dump de la base
mysqldump --no-tablespaces --single-transaction -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" | gzip > "$DEST/db.sql.gz"

# 2. Archive des fichiers essentiels
tar czf "$DEST/fichiers.tar.gz" -C "$WEBROOT" \
    --exclude='var/cache' --exclude='var/logs' --exclude='backup_ps' \
    img themes modules override config mails translations 2>/dev/null

# 3. Ne garder que les 2 dernières sauvegardes
find "$BACKUP_DIR" -maxdepth 1 -mindepth 1 -type d -name '20[0-9][0-9]-*' | sort -r | tail -n +3 | xargs -r rm -rf