Errcode: 2 Problem in using Infile

[Safi Siddiqui]

Sorry. My Mistake, put the question in wrong place in the forums. How do I delete the question? =/

_________________________________

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.



Edited 1 time(s). Last edit at 04/26/2012 02:20PM by Safi Siddiqui.