Data set not found during load data infile

Hello experts:
I'm having a problem trying to do a load dat infile in mysql.
I get this error message: File 'c:\extract.dat' not found (Errcode: 2)

here's my query:
LOAD DATA INFILE 'c:\\extract.dat' INTO TABLE extract FIELDS TERMINATED BY '|';

The extract.dat exists on the c:drive.

thanks
lancerxeAsked:
Who is Participating?
 
steelseth12Connect With a Mentor Commented:
try

LOAD DATA INFILE 'c:/extract.dat' INTO TABLE extract FIELDS TERMINATED BY '|';
0
 
Ruben CornejoConnect With a Mentor CINCommented:
Thats rigth lancer...you need to use slash '/'  in you path to the file instead of backslash '\' like we usualy do in widnows
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.