mysql-gui怎么执行_MySQL 执行大量语句时的正确姿势？ mysql *.sql ？ 使用 GUI？

2

-07-22 22:14:01 +08:00 1

以前写的. 要出错的你得加些去获取source的process

#!/bin/bash

`

set -e

LC_ALL=C

LANG=C

unset TZ

TZBase=$(LC_ALL=C TZ=UTC0 date -R)

UTdate=$(LC_ALL=C TZ=UTC0 date -d "$TZBase")

TZdate=$(unset TZ ; LANG=C date -d "$TZBase")

file_path="/home/www/db/bigdb/test/" #要导入的sql文件夹

host="192.168.85.123" #要导入的mysql主机

username="db4mysql" #mysql的用户名

password="db4pwd" #mysql的密码

dbname="sample" #mysql的数据库名

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

`