Sunday, 25 August 2013

ERROR 1148: The used command is not allowed with this MySQL version

ERROR 1148: The used command is not allowed with this MySQL version

I am trying to load data into mysql database using
LOAD DATA LOCAL
INFILE A.txt
INTO DB
LINES TERMINATED BY '|';
the topic of this question is the response I get. I understand the local
data offloading is off by default and I have to enable it using a the
command local-infile=1 but I do not know where to place this command.

No comments:

Post a Comment