MySQL LOAD DATA Error can't resolve...!

Question

mysql> LOAD DATA INFILE '/abc.txt' INTO TABLE test1 FIELDS TERMINATED BY '|';
ERROR 13 (HY000): Can't get stat of '/abc.txt' (Errcode: 2)

I used LOAD DATA as per the syntax. But getting the above error. can anybody tell what is the error..!? I tried searching google dev.mysql can't find what error it is??

Thanks in advance

can you show us the "stat /abc.txt" output. possibly related to file permissions error. lists.mysql.com/mysql/206087 — zer0bit
– zer0bit, Commented Dec 26, 2012 at 9:35
Does the mysqld process have permission to access the file? — eggyal
– eggyal, Commented Dec 26, 2012 at 10:54

Kermit · Accepted Answer · 2013-04-11 22:06:01Z

5

If the file is on your MYSQL server try using the full path.

LOAD DATA INFILE '/var/tmp/abc.txt' INTO TABLE test1 FIELDS TERMINATED BY '|';

If the file isn't on the server and it is on your local machine, and your user has access to SCP files between the servers ( try this

scp abc.txt mysqlserver:

) then you should be able to do this (using full path again) ..

LOAD DATA LOCAL INFILE '/var/tmp/abc.txt' INTO TABLE test1 FIELDS TERMINATED BY '|';

If that doesn't work.. try renaming the file to test1.txt and using the 'mysqlimport' command?

edited Apr 11, 2013 at 22:06

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

answered Apr 11, 2013 at 22:01

ryansstack

1,4961 gold badge18 silver badges33 bronze badges

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

1 Comment

prototype Over a year ago

That was the clue I was seeking. On EC2, copying the file from user directory (/home/me/mydata/mydata.csv) to /var/tmp/mydata.csv worked

KayV · Accepted Answer · 2018-10-17 09:29:26Z

0

Login to the mysql console using the following flag:

mysql -uroot -p --local-infile

and then enter the password.

After that execute the load data command as follows:

LOAD DATA LOCAL INFILE '/abc.txt' INTO TABLE test1 FIELDS TERMINATED BY '|';

answered Oct 17, 2018 at 9:29

KayV

14k17 gold badges106 silver badges156 bronze badges

Collectives™ on Stack Overflow

MySQL LOAD DATA Error can't resolve...!

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related