#!/bin/bash
#########################################
#Function:    export_all_sql
#Usage:       bash export_all_sql.sh
#Version:     1.0  2024.05.09
#Blog:        http://www.19aq.com/
#Team:        Roots Exploits Team
#########################################
DIR=/www/wwwroot/
DATA=$(ls -l "$DIR" | awk '{print$9}')
error_handler() {
    echo "mysql数据库 导出 账户 异常,未建立/无权限等"
    exit 1
}
for i in $DATA
do
    CUR_DIR=$DIR$i
    PC_FILE="$CUR_DIR/data/common.inc.php"
    if [ -f "$PC_FILE" ]; then
        # 如果存在,进行重写
        NAME="${i//[-.]/_}"
        NAME="${NAME,,}"
        trap 'error_handler' ERR
        if ! [ -d "/root/sql/" ]; then
            mkdir /root/sql/
        fi
        mysqldump -uc32 -pc32 $NAME >/root/sql/$NAME.sql
        
        echo $NAME"----write sql success"
    fi
done