自动创建数据库并按顺序导入sql文件的shell脚本

#!/bin/bash#author     xiaobao #date       2017-3-22 9:39:27set -eLC_ALL=CLANG=Cunset TZTZBase=$(LC_ALL=C TZ=UTC0 date -R)UTdate=$(LC_ALL=C TZ=UTC0 date -d "$TZBase")TZdate=$(unset TZ ; LANG=C date -d "$TZBase")#要导入的sql文件夹file_path_create="/xiaobao/db/"                 file_path_insert="/xiaobao/db/"                 file_path_produre="/xiaobao/db/"   #要导入的mysql主机          host="192.168.133.22" #端口号                                    port="3306"   #mysql的用户名                                          username="root" #mysql的密码                                           password="root"  #mysql的数据库名                                         dbname="xiaobao_db" #创建数据库                                      create_db_sql="create database IF NOT EXISTS ${dbname}" mysql -h${host}  -P${port}  -u${username} -p${password} -e "${create_db_sql}"#计时now=$(date "+%s")                                          mysql_source(){    for file_name in `ls -A $1`    do        seg_start_time=$(date "+%s")        if [ -f "$1$file_name" ];then            command="source $1$file_name"            mysql -h${host} -u${username} -p${password} ${dbname} -e "$command"            echo "source:" \"$1$file_name\" "is ok, It takes " `expr $(date "+%s") - ${seg_start_time}` " seconds"        fi    done    echo "All sql is done! Total cost: " `expr $(date "+%s") - ${now}` " seconds"}echo "Universal Time is now:  $UTdate."echo "Local time is now:      $TZdate."mysql_source $file_path_createmysql_source $file_path_insertmysql_source $file_path_produre

此shell脚本的功能是自动创建数据库cdn_xiaobao，并按顺序依次导入/xiaobao/db/，/xiaobao/db/和/xiaobao/db/目录下的sql文件，并会将导入每个目录下的sql文件打印出来，经测试可用。欢迎大家测试使用，有什么问题请随时留言反馈，谢谢！