Skip navigation links

MySQL Forums :: Other Migration :: LOAD DATA from file = (Errcode: 2)


Advanced Search

LOAD DATA from file = (Errcode: 2)
Posted by: joe bushee ()
Date: September 01, 2004 06:42PM

Tried running graphical interface at client, from server, and also connecting to server from client via command line.

LOAD DATA LOCAL INFILE 'c:\\site.txt' INTO TABLE `hikes` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

produces error:

File ''c:\site.txt' not found (Errcode: 2)

(also tried site.csv, which is what I used to populate the table on my local test webserver) Any assistance appreciated..

Joe

Options: Reply•Quote


Subject Views Written By Posted
LOAD DATA from file = (Errcode: 2) 32424 joe bushee 09/01/2004 06:42PM
Re: LOAD DATA from file = (Errcode: 2) 13475 Nick Roper 09/02/2004 09:35AM
Re: LOAD DATA from file = (Errcode: 2) 12413 joe bushee 09/02/2004 10:26AM
Re: LOAD DATA from file = (Errcode: 2) 13076 Arnaldo Bustamante 12/15/2008 10:37AM
Re: LOAD DATA from file = (Errcode: 2) 9776 Nick Roper 09/02/2004 10:38AM


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

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.