mysql批量导出单结构与结构数据表脚本

#!/bin/bash
#*************************************************************************
#         > File Name: export_mysql.sh
#         > Author: chenglee
#         > Main : chengkenlee@sina.com
#         > Blog : http://www.cnblogs.com/chenglee/
#         > Created Time : Thu 28 Mar 2019 10:37:58 PM CST
#*************************************************************************

UIP="127.0.0.1"
UUSER="root"
UPASS="123456"
UDATABASES="wordpress"

function Export_Framework(){
    exec 1<"table"
    while read line1<&1
    do
        mysqldump -u ${UUSER}  -p${UPASS} -d ${UDATABASES} ${line1} > Export_Framework/${line1}.sql
    done
}
function Export_Data(){
    exec 2<"table"
    while read line2<&2
    do
        mysqldump  -u ${UUSER}  -p${UPASS} ${UDATABASES} ${line2} > Export_Data/${line2}.sql
    done
}
function Table(){
    if [ -f "table" ];then
        echo "table文件存在,即将开始导出相关数据表结构与数据"
        sleep 2;
        if [[ -d "Export_Framework" && -d "Export_Data" ]];then
            Export_Framework
            Export_Data
        else
            mkdir Export_Framework Export_Data
            Export_Framework
            Export_Data
        fi
    else
        echo "table文件不存在,请先创建命名为:table的文件,并在里面写入需要操作的数据表,再运行此脚本"
        exit;
    fi
}
function main(){
    Table
}
main