在linux下使用mysql导入数据,如
LOAD DATA LOCAL INFILE '~/mysql/dbgen/nation.tbl' INTO TABLE nation FIELDS TERMINATED BY "|" LINES TERMINATED BY '|\n'
遇到如下错误:
ERROR 1148 (42000): The used command is not allowed with this MySQL version
解决方法:
在进入mysql时添加 "--local-infile=1",即把“mysql -uroot -p”修改为"mysql -root --local=infile=1 -p"。
参考网址: