#!/bin/bash

# MySQL Database Restore Script for Musical Marketplace
# Usage: ./restore_database.sh backup_file.sql

if [ $# -eq 0 ]; then
    echo "Usage: $0 <backup_file.sql>"
    echo "Example: $0 backups/metajack_marketplace_full_20250927_024547.sql.gz"
    exit 1
fi

BACKUP_FILE=$1
DB_NAME="metajack_marketplace"
DB_USER="mjack"
DB_PASS="NnBSN9i2xUKg"

if [ ! -f "$BACKUP_FILE" ]; then
    echo "Error: Backup file '$BACKUP_FILE' not found!"
    exit 1
fi

echo "Restoring database $DB_NAME from $BACKUP_FILE..."

# Check if file is compressed
if [[ $BACKUP_FILE == *.gz ]]; then
    echo "Decompressing and restoring..."
    gunzip -c "$BACKUP_FILE" | mysql -u $DB_USER -p$DB_PASS $DB_NAME
else
    echo "Restoring from uncompressed file..."
    mysql -u $DB_USER -p$DB_PASS $DB_NAME < "$BACKUP_FILE"
fi

if [ $? -eq 0 ]; then
    echo "Database restored successfully!"
else
    echo "Error occurred during restore!"
    exit 1
fi