• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

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
0
lancerxe
Asked:
lancerxe
2 Solutions
 
steelseth12Commented:
try

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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now