MySQL Loading Data Error

Question

LOAD DATA
LOCAL INFILE "file.txt"
REPLACE INTO TABLE file
FIELDS TERMINATED BY '|'
(attribute1, attribute2)
LOAD DATA
LOCAL INFILE "file2.txt"
REPLACE INTO TABLE file2
FIELDS TERMINATED BY '|'
(attribute3, attribute4)

I have a single text file composed of several of these "LOAD DATA" commands. I receive an error message saying line 6, or the start of the 2nd command, is not proper syntax. And if I try to introduce a "lines terminated by '\n'" code, it says it is not allowed with my mysql version.

Perhaps you need to terminate the individual `LOAD DATA` statements? — Kermit, Oct 21 '13 at 17:10
Yes, you should add a ';' at the end of each load statement. And what version of MySQL you are using? — Shockley, Oct 21 '13 at 17:12
The ';' helped remove the 2nd error message, but now it points to line 1 and says "the used command is not allowed with this mysql version". — user2574635, Oct 21 '13 at 17:15
try add local-infile=1 into your [mysqld], see this http://stackoverflow.com/questions/10762239/enable-load-data-local-infile — Shockley, Oct 21 '13 at 17:18
the addition of --local-infile worked. Thanks for the help, everyone. — user2574635, Oct 21 '13 at 17:29

score 1 · Accepted Answer · edited May 23 '17 at 12:10

You should add a ';' at the end of each load statement.

LOAD DATA
LOCAL INFILE "file.txt"
REPLACE INTO TABLE file
FIELDS TERMINATED BY '|'
(attribute1, attribute2);


LOAD DATA
LOCAL INFILE "file2.txt"
REPLACE INTO TABLE file2
FIELDS TERMINATED BY '|'
(attribute3, attribute4);

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

You can specify that as an additional option when setting up your client connection:

mysql -u myuser -p --local-infile somedatabase

MySQL Loading Data Error

1 Answers1