Oct 10, 2018

How to solve "( load data local infile ) The used command is not allowed with this MySQL version"

If the server is started with the option to disable LOAD DATA then a client has to explicitly Enable LOAD DATA LOCAL INFILE.

For the mysql command-line client, enable LOAD DATA LOCAL by specifying the --local-infile[=1] option, or disable it with the --local-infile=0 option.

For mysqlimport, local data file loading is off by default; enable it with the --local or -L option. In any case, successful use of a local load operation requires that the server permits it.