Errcode: 2 Problem in using Infile
Hello,
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
(DCES_Id,Consumer_name,Consumer_Address,Billing_Month,DCES_Present_Reading,DCES_Previous_Reading,DCES_Unit_Consumption,DCES_Energy_Charges,DCES_Surcharges,DCES_Total,DCES_Late_payment,DCES_Due_date);
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.