[MySQL][SSC] Fortify SSC DB 초기화 스크립트

#!/bin/bash
TMP_FILE="/tmp/__reset_db__.sql"
DB_NAME="db_ssc_2222"
BACKUP_SQL_FILE="/root/db_backup/20240119_db_ssc_2222-mysql.sql"
DB_USER="root"
DB_PASS='<PASSWORD>'

echo "DROP DATABASE IF EXISTS ${DB_NAME};" > ${TMP_FILE}
echo "CREATE DATABASE ${DB_NAME} CHARACTER SET utf8mb3 COLLATE utf8mb3_bin;" >> ${TMP_FILE}
mysql -u ${DB_USER} -p${DB_PASS} < ${TMP_FILE}
mysql -u ${DB_USER} -p${DB_PASS} ${DB_NAME} < ${BACKUP_SQL_FILE}
rm -f ${TMP_FILE}

@ECHO OFF
SET "TMP_FILE=%TEMP%\__reset_db__.sql"
SET "DB_NAME=db_ssc_2320"
SET "BACKUP_SQL_FILE=C:\ssc_data\db_backup\db_ssc_2320.sql"
SET "DB_USER=root"
SET "DB_PASS=<PASSWORD>"

ECHO DROP DATABASE IF EXISTS %DB_NAME%;> %TMP_FILE%
ECHO CREATE DATABASE %DB_NAME% CHARACTER SET utf8mb3 COLLATE utf8mb3_bin;>> %TMP_FILE%
mysql -u %DB_USER% -p%DB_PASS% < %TMP_FILE%
mysql -u %DB_USER% -p%DB_PASS% %DB_NAME% < %BACKUP_SQL_FILE%
DEL /F /Q %TMP_FILE%
PAUSE