Linux下Mysql导入大量数据到一张表

可以利用shell脚本将切分好的文件分别导入，大文件可以利用split -l 50000 big_file small_file_ 进行切分为小文件。

#!/bin/bash

HOSTNAME="127.0.0.1"
PORT="3306"
USERNAME="root"
PASSWORD="root"
DBNAME="test"
TABLENAME="t_user"
suffix="a b c d e f g h i j"
for i in ${suffix}
do
insert_sql="LOAD DATA LOCAL INFILE 'user_file_a$i'
INTO TABLE test.t_user FIELDS TERMINATED BY '|' 
(c_user_name, c_password)"
mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${insert_sql}"
echo 'insert user_a'$i
echo ${insert_sql}
done