#!/bin/bash

# 사용법:
# ./backup_mysql_db.sh [MySQL사용자명] [데이터베이스명]

USER_NAME="$1"
DB_NAME="$2"

if [ -z "$USER_NAME" ] || [ -z "$DB_NAME" ]; then
  echo "사용법: $0 [MySQL사용자명] [데이터베이스명]"
  echo "예시: $0 ns40_1 ns40_1"
  exit 1
fi

DATE_TIME=$(date +"%Y%m%d_%H%M%S")
BACKUP_FILE="${DB_NAME}_${DATE_TIME}.sql"

mysqldump -u "$USER_NAME" -p --no-tablespaces \
  --routines --triggers --events \
  "$DB_NAME" > "$BACKUP_FILE"

if [ $? -eq 0 ]; then
  echo "백업 완료: $BACKUP_FILE"
else
  echo "백업 실패"
  rm -f "$BACKUP_FILE"
  exit 1
fi