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
– Kermit, Commented Oct 21, 2013 at 17:10
Yes, you should add a ';' at the end of each load statement. And what version of MySQL you are using? — Shockley
– Shockley, Commented Oct 21, 2013 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
– user2574635, Commented Oct 21, 2013 at 17:15
try add local-infile=1 into your [mysqld], see this stackoverflow.com/questions/10762239/… — Shockley
– Shockley, Commented Oct 21, 2013 at 17:18

Community · Accepted Answer · 2017-05-23 12:10:59Z

1

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

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Oct 21, 2013 at 17:15

Tony

17.9k17 gold badges85 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Loading Data Error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related