mysql -u [youruser] -h [youraddress] -p [yourpassword] [yourdatabase] --local-infile=1 -e "[yourcmd]"
example：
mysql -uroot -p123456 book --local-infile=1 -e "load data local infile ‘/home/hp/test.txt‘into table test fields terminated by ‘ ‘;"
mysql导入格式化txt数据(超快),布布扣,bubuko.com
原文：http://www.cnblogs.com/purples/p/3598001.html