Errcode: 2 Problem in using Infile
Posted by: Safi Siddiqui
Date: April 26, 2012 02:18PM
I'm having an issue with loading data into a table using load script.
This is my script:
LOAD DATA INFILE 'C:\Users\m\Desktop\a2\DCES.dat'
into table test_table
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
IGNORE 3 LINES
Every time I run this script it gives the error: "#29 - File 'C:\xampp\mysql\data\UsersmDesktopa22DCES.dat' not found (Errcode: 2)"
I tried adding 'LOCAL' to the script, but it just gave me a new error. "#7890 - Can't find file 'C:UsersmDesktopa22DCES.dat'."
Also, the path I have given is correct, I have checked, and rechecked it. The file is absolutely present at this location, but it is not being found.
Any help would be greatly appreciated.