#!/bin/bash

# 설정
SOURCE_USER="root"
SOURCE_PASSWORD="admin01"
SOURCE_DATABASE="proshield"
TABLES=("MAIL_POLICY_CONDITION" "MAIL_POLICY")
DUMP_DIR="/usr/local/apache/htdocs/mailfilter"
TARGET_USER="root"
TARGET_PASSWORD="admin01"
TARGET_DATABASE="proshield"
TARGET_HOSTS=("10.251.2.42" "10.251.2.43" "10.251.2.44")

# 각 테이블 덤프
for TABLE in "${TABLES[@]}"; do
    DUMP_FILE="$DUMP_DIR/dump_$TABLE.sql"
    /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 $TABLE to $HOST"
        else
            echo "Successfully transferred $TABLE to $HOST"
        fi
    done
done