解决方案:在登录mysql的时候,显式的加上 - -local-infile这个参数即可。
即:mysql - -local-infile -u user -ppasswd
登陆成功后,执行load data [local] infile 'filename' into table xxx.xxx(字段);
出现这个错误的原因是:If LOAD DATA LOCAL is disabled, either in the server or the client, a client that attempts to issue such a statement receives the following error message:
ERROR 1148: The used command is not allowed with this MySQL version
可见,出于安全考虑,默认是不允许从client host远程通过load data命令导数据的。