#!/bin/bash

MYSQL_USER="root"
MYSQL_PASS="password"

DB_LIST=(
"DB1"
"DB2"
"DB3"
)

LOG_FILE="/www/wwwlogs/truncate_whos_online.log"

echo "========== $(date '+%F %T') 开始执行 ==========" >> $LOG_FILE

for DB in "${DB_LIST[@]}"; do
    echo "正在清理数据库：$DB" >> $LOG_FILE

    mysql -u"$MYSQL_USER" -p"$MYSQL_PASS" "$DB" -e "TRUNCATE TABLE \`whos_online\`;" >> $LOG_FILE 2>&1

    if [ $? -eq 0 ]; then
        echo "成功：$DB.whos_online 已清空" >> $LOG_FILE
    else
        echo "失败：$DB.whos_online 清空失败" >> $LOG_FILE
    fi
done

echo "========== $(date '+%F %T') 执行结束 ==========" >> $LOG_FILE
echo "" >> $LOG_FILE