I m unable to load data into MYSQL tables. Getting Errcode: 2

[Uma Bharath]

mysql> LOAD DATA
-> LOCAL INFILE "C:/Database/Datafile.txt"
-> REPLACE INTO TABLE dm.a
-> FIELDS TERMINATED BY ','
-> (tid,tname)
-> ;
ERROR 2 (HY000): File 'C:\Database\Datafile.txt' not found (Errcode: 2)

Even i tired giving


mysql> LOAD DATA
-> LOCAL INFILE "C:\Database\Datafile.txt"
-> REPLACE INTO TABLE dm.a
-> FIELDS TERMINATED BY ','
-> (tid,tname)
-> ;
ERROR 2 (HY000): File 'C:IDCDatabaseDatafile.txt' not found (Errcode: 2)
mysql>

The Database and Datafile has given permission and the file is existing in the given location.

What else i have to do for successful loading of data in to the already created table in MYSQL.

Any help would be appreciated.

Thanks



Edited 3 time(s). Last edit at 04/11/2010 11:49PM by Uma Bharath.