运行Load data local infile命令时:
mysql> LOAD DATA LOCAL INFILE '/path/file' INTO TABLE tablename;
出现:
ERROR 1148 (42000): The used command is not allowed with this MySQL version
这是因为:
服务器端,local_infile默认开启;客户端,local_infile默认关闭,因此用的时候需要打开。
On the server side:
The local_infile system variable controls server-side LOCAL capability. Depending on the local_infile setting, the server refuses or