MySQL Forums
Forum List  »  Other Migration

I m unable to load data into MYSQL tables. Getting Errcode: 2
Posted by: Uma Bharath
Date: April 11, 2010 11:34PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
I m unable to load data into MYSQL tables. Getting Errcode: 2
4949
April 11, 2010 11:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.