#!/bin/bash
# Nightly DB + storage backup. Add to cron:
#   0 2 * * * /home/voiceagent/backup.sh
set -e
APP=/home/voiceagent/public_html/data.matladu.com
DEST=/home/voiceagent/backups
STAMP=$(date +%Y%m%d-%H%M%S)
mkdir -p "$DEST"

# DB creds from .env
DB=$(grep '^DB_DATABASE=' "$APP/.env" | cut -d= -f2)
USER=$(grep '^DB_USERNAME=' "$APP/.env" | cut -d= -f2)
PASS=$(grep '^DB_PASSWORD=' "$APP/.env" | cut -d= -f2-)

mysqldump -u"$USER" -p"$PASS" "$DB" | gzip > "$DEST/db-$STAMP.sql.gz"
tar -czf "$DEST/storage-$STAMP.tar.gz" -C "$APP" storage/app

# Keep last 14 days
find "$DEST" -name '*.gz' -mtime +14 -delete
echo "Backup complete: $STAMP"