#!/bin/bash
set -e  # Exit on error

# --- CONFIGURATION ---
DB_NAME="farm_accounts"
DB_USER="nodor"
DB_PASS="D@n33Nao40"
EMAIL_TO="nodor@nykoinc.com"
BACKUP_DIR="/var/www/wcfs/tabs/db_backups"
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_FILE="$BACKUP_DIR/db_backup_${DB_NAME}_$DATE.sql.gz"

# --- Ensure backup directory exists ---
mkdir -p "$BACKUP_DIR"

# --- Create database backup ---
mysqldump -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" | gzip > "$BACKUP_FILE"

# --- Verify and email backup ---
if [ -f "$BACKUP_FILE" ]; then
    echo "Attached is the latest backup for database: $DB_NAME" | \
    mutt -s "Database Backup for $DB_NAME ($DATE)" \
    -a "$BACKUP_FILE" -- "$EMAIL_TO"

    # Delete the backup file after sending
    rm "$BACKUP_FILE"
else
    echo "Backup failed: $BACKUP_FILE was not created."
fi