可以利用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