#!/bin/bash
# Script pour importer le dump SQL dans la base locale

set -e

DB_USER="salagombooking"
DB_PASSWORD="R76SgJP8LK9cnxsA"
DB_NAME="salagombooking"
DUMP_FILE="../www/salagombooking.sql"

echo "🔄 Import du dump SQL dans la base locale..."
mysql -S /tmp/mysql.sock -u "$DB_USER" -p"$DB_PASSWORD" "$DB_NAME" < "$DUMP_FILE"

echo "✅ Import terminé!"
echo ""
echo "📊 Tables importées:"
mysql -S /tmp/mysql.sock -u "$DB_USER" -p"$DB_PASSWORD" "$DB_NAME" -e "SHOW TABLES;"