Digital Marketing

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.

Popular posts from this blog

How to fix Google Apps Script: Script function not found: doGet

Creating sort index in MySQL

How to fix: df shows no file systems processed on Linux