Gecko [ sacpinlaptop.com ]

Name	Size	Permission	Date
checkdisk2	[ DIR ]	drwxr-xr-x	2026-07-26 09:09
check_all_mysql_db_sizes.sh	1.77 KB	-rwxr-xr-x	2025-07-24 18:31
check_avail_backup.sh	2.34 KB	-rwx------	2026-03-19 00:44
check_disk.sh	3.45 KB	-rwxr-xr-x	2025-10-27 01:19
check_disk.sh.1108902.2025-08-23@08:17:25~	8.85 KB	-rwxr-xr-x	2025-08-11 17:34
check_disk.sh.3561032.2025-08-12@00:34:45~	8.94 KB	-rwxr-xr-x	2025-07-25 01:10
check_disk.sh.531086.2025-10-27@08:19:41~	8.85 KB	-rwxr-xr-x	2025-08-23 01:17
check_disk_health.sh	2.87 KB	-rwx------	2026-03-13 03:59
checkbk.sh	1.84 KB	-rwx------	2025-12-29 06:46
collect_cpanel_full_info.sh	5.38 KB	-rwx------	2026-01-29 03:47
get_the_domains.sh	398 B	-rwx------	2026-06-25 10:02
hosting_full.json	179.97 KB	-rw-------	2026-09-25 18:00
report-backup.sh	1.9 KB	-rwxr-xr-x	2025-05-24 03:57
sync_backup.sh	2.18 KB	-rwxr-xr-x	2026-04-09 01:39

Rename

#!/bin/bash

# ====== CẤU HÌNH TELEGRAM ======
BOT_TOKEN="5971131875:AAF1Z11CyKhbpmkXzrMxePMVL0dqT1vusXo"
CHAT_ID="-803396545"
URL="https://telegram.hongmanh.net/bot$BOT_TOKEN/sendMessage"

URLGGCHAT="https://chat.googleapis.com/v1/spaces/AAQAf1kJwt4/messages?key=AIzaSyDdI0hCZtE6vySjMm-WEfRq3CPzqKqqsHI&token=gnFbbi-wazOAn_y0jUW36CFQSLVyyqNYW0QgcibhilY"

# ====== LẤY IP SERVER ======
SERVER_IP=$(hostname -I | awk '{print $1}')
HOSTNAME=$(hostname)

# ====== TIÊU ĐỀ ======
HEADER="📢 CẢNH BÁO DATABASE LỚN TRÊN SERVER $HOSTNAME ($SERVER_IP)"
BODY=""
HAS_LARGE_DB=false

# ====== KIỂM TRA MYSQL ======
if ! mysqladmin ping &> /dev/null; then
    MESSAGE="❌ Không thể kết nối đến MySQL trên server $HOSTNAME ($SERVER_IP)"
	curl -s -X POST $URL -d "chat_id=$CHAT_ID" -d text="$MESSAGE" > /dev/null
    exit 1
fi

# ====== LẤY DANH SÁCH DATABASE ======
databases=$(mysql -N -B -e "SHOW DATABASES;" | grep -Ev "^(information_schema|performance_schema|mysql|sys)$")

for db in $databases; do
    size_bytes=$(mysql -N -B -e "SELECT SUM(data_length + index_length) FROM information_schema.tables WHERE table_schema='$db';")
    if [[ "$size_bytes" -gt 2147483648 ]]; then
        size_gb=$(echo "scale=2; $size_bytes / 1024 / 1024 / 1024" | bc)
        BODY+="🔸 $db: ${size_gb} GB\n"
        HAS_LARGE_DB=true
    fi
done

# ====== GỬI TELEGRAM & GG CHAT ======
TEXT=$(echo -e "$HEADER\n\n$BODY")

if $HAS_LARGE_DB; then
    #curl -s -X POST $URL \
     #   -d "chat_id=${CHAT_ID}&parse_mode=Markdown&text=$(echo -e "$TEXT")"

curl -s -X POST $URL -d "chat_id=$CHAT_ID" -d text="$TEXT" > /dev/null
    curl -s -X POST "$URLGGCHAT" -H 'Content-Type: application/json' -d "{\"text\": \"$TEXT\"}" > /dev/null

else
    echo "Không có database nào vượt quá 2GB."
fi