mysql loader error? 'C:test.txt' not found (Errcode: 2)

Question

I tried the following code to load data from text document (file name is test.txt) to MySQL database, but it shows an error:

File 'C:test.txt' not found (Errcode: 2)

The query is:

LOAD DATA LOCAL INFILE 'C:test.txt' INTO TABLE messagebox  fields terminated by ','  LINES TERMINATED BY '\n';

`LOAD DATA LOCAL INFILE` __'C:test.txt'__ `INTO TABLE` – Robik Feb 05 '12 at 14:04 — Robik, Feb 05 '12 at 14:04

score 3 · Answer 1 · answered Feb 05 '12 at 14:06

3

modify your drive address to C:\\test.txt

LOAD DATA LOCAL INFILE 'C:\\test.txt'

INTO TABLE 'messagebox'

fields terminated by ',' fields escaped by '\\' LINES TERMINATED BY '\n';

answered Feb 05 '12 at 14:06

Skyrel

I have a question here: Is the last line in the answer for specifying paths or for the content of the txt file? – Solace Apr 22 '14 at 23:55

score 1 · Answer 2 · answered Oct 23 '12 at 11:09

1

@Skyrel answer is perfect.In addition to that for Ubuntu users, use this command

LOAD DATA LOCAL INFILE '/home/user/test.txt'

answered Oct 23 '12 at 11:09

Ankit Saxena

score 0 · Answer 3 · answered Feb 05 '12 at 14:04

0

You need a slash in your url

c:\test.txt

answered Feb 05 '12 at 14:04

Ash Burlaczenko

3 Answers3