No such file or directory in MySQL SQL script

Question

I have a SQL script that contains the following

LOAD DATA LOCAL INFILE '.\\datafiles\\customers.txt' INTO TABLE Customers`

I open and run it in MySQL workbench and I get following error:

Error Code: 2. File '.\datafiles\customers.txt' not found 
  (Errcode: 2 - No such file or directory)

Where should I put file customers.txt according '.\datafiles\customers.txt'?

I use windows 7 and I tried the following placse:

C:\datafiles
C:\temp\datafiles
C:\tem\datafiles
C:\Users\michael\datafiles

Mad Dog Tannen · Accepted Answer · 2014-01-14 14:00:52Z

1

I think \\ is incorrect. I Always use full path.

So if the file is in C:\datafiles\ use

LOAD DATA LOCAL INFILE 'C:\datafiles\customers.txt' 
INTO TABLE Customers LINES TERMINATED BY '\r\n';

answered Jan 14, 2014 at 14:00

Mad Dog Tannen

7,2505 gold badges34 silver badges55 bronze badges

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

3 Comments

michdraft Over a year ago

\\` is correct because when i change it to 'C:\\datafiles\\customers.txt'` it works fine.

Mad Dog Tannen Over a year ago

Can i ask why you use double \?

michdraft Over a year ago

I did not use double \. It is in the sql script which i get it from developer company and i'm not allowed to change it. just i should know where is the correct location of file on my computer.

Anastasios Vlasopoulos · Accepted Answer · 2014-01-14 14:05:57Z

0

Use absolute path with slash as a separator like this:

'C/your_folder/.../datafiles/customers.txt'

answered Jan 14, 2014 at 14:05

Anastasios Vlasopoulos

1,80223 silver badges34 bronze badges

2 Comments

michdraft Over a year ago

i don't want to change anything in the sql script. i should just put the file in the correct location in windows.

Anastasios Vlasopoulos Over a year ago

Maybe you should try to put your file in your SQL installation folder. Create the datafiles folder in there and see if it works.

Collectives™ on Stack Overflow

No such file or directory in MySQL SQL script

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related