#!/bin/bash

# 설정
SOURCE_USER="root"
SOURCE_PASSWORD="admin01"
SOURCE_DATABASE="proshield"
TABLE="MAIL_POLICY_CONDITION"
DUMP_FILE="/usr/local/apache/htdocs/mailfilter/dump.sql"
TARGET_USER="root"
TARGET_PASSWORD="admin01"
TARGET_DATABASE="proshield"
TARGET_HOSTS=("10.251.2.42" "10.251.2.43" "10.251.2.44")

# 데이터베이스 덤프
/usr/local/mysql/bin/mysqldump -u"$SOURCE_USER" -p"$SOURCE_PASSWORD" "$SOURCE_DATABASE" "$TABLE" > "$DUMP_FILE"

if [ $? -ne 0 ]; then
    echo "Error dumping table $TABLE"
    exit 1
else
    echo "Successfully dumped table $TABLE to $DUMP_FILE"
fi

# 각 타겟 서버로 데이터 전송
for HOST in "${TARGET_HOSTS[@]}"; do
    mysql -h "$HOST" -u "$TARGET_USER" -p"$TARGET_PASSWORD" "$TARGET_DATABASE" < "$DUMP_FILE"
    if [ $? -ne 0 ]; then
        echo "Error transferring to $HOST"
    else
        echo "Successfully transferred to $HOST"
    fi
done