#!/bin/bash
set -e
set -x

# Variables
DB_USER="ciaran"
DB_PASSWORD="Cn18012009"
DB_NAME="pod_rota"
BACKUP_DIR="/mnt/ssd_data/my_sport_manager_db_backups"
DATE=$(date +'%Y-%m-%d')

# Create backup, excluding the 'pods' table
mysqldump -u "$DB_USER" -p"$DB_PASSWORD" --ignore-table="$DB_NAME.pods" "$DB_NAME" > "$BACKUP_DIR/my_sport_manager_db_backup_$DATE.sql"

# Optional: Print a message indicating the backup was successful
if [ $? -eq 0 ]; then
    echo "Backup of database '$DB_NAME' created successfully at '$BACKUP_DIR/my_sport_manager_db_backup_$DATE.sql'"
else
    echo "Backup failed."
fi