Link to home
Start Free TrialLog in
Avatar of lancerxe
lancerxe

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of steelseth12
steelseth12
Flag of Cyprus image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial