MySQL Forums
Forum List  »  Newbie

load data infile errorcode 2
Posted by: Jon Lee
Date: December 07, 2009 12:51PM

I am trying to load data from a text file into an table. I am running server version 5.1.41 and client version 5.1.11. Clent and server are running on my local PC. I cannot get past the file not found errorcode 2. I have used the command with and without the "local" keyword without success. I have verified that the text file is in the database directory. I have tried it with the path explicitly defined and without the path. I have used both the forward slash path designation "/" and the double back slash designation"\\".

Having spent a considerable amount of time doing searches on this error without result I am reaching out to anyone who has a clue about this issue.

Here is my query and result:

mysql> load data infile 'nw.txt' into table import_perf_pnc;
ERROR 29 (HY000): File 'C:\Documents and Settings\All Users\Application Data\MyS
QL\MySQL Server 5.1\Data\perf_db\nw.txt' not found (Errcode: 2)

Thanks in advance for any help that I can receive.

Options: ReplyQuote


Subject
Written By
Posted
load data infile errorcode 2
December 07, 2009 12:51PM
December 08, 2009 08:17AM
December 08, 2009 08:42AM
December 08, 2009 08:51AM
December 08, 2009 09:24AM
December 08, 2009 09:50AM
December 08, 2009 10:48AM


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.