Re: LOAD DATA - Bob Kline - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: LOAD DATA

From	Sent On	Attachments
Bob Kline	19 Oct 1999 06:16
Marcel Lindenbergh	19 Oct 1999 06:22
sin...@cytanet.com.cy	19 Oct 1999 06:35
Bogdan Paduraru	19 Oct 1999 16:37

Subject:	Re: LOAD DATA
From:	Bob Kline (bkl...@rksystems.com)
Date:	10/19/1999 06:16:55 AM
List:	com.mysql.lists.mysql

On Tue, 19 Oct 1999, Marcel Lindenbergh wrote:

Hello,

Can anyone tell me what errorcode 2 is? When I use LOAD DATA INFILE 'path_to_file' INTO .... I always get this error: Couldn't get stat of 'path_to_file'

Is this maybe because I don't have the file privilege? It's a remote database to which I don't have access to, so I have to use an absolute path. MySQL always returns this error, what am I doing wrong? The same error occurs when I use the LOCAL keyword for importing a local datafile.

The syntax of the statement I use is correct, coz everything works fine on my MySQL database.

Please help! I don't want to insert 1500 records myself everytime! Is there another way of doing this maybe?

Hard to say for sure, since you haven't told us anything about the platform on which you are running. Let me guess Linux or Win32, though, in which case it means there is no such file in the file system. Check the spelling (and the direction and number of slashes) very carefully.

I'm not sure what to make of the sentence "The syntax of the statement I use is correct, coz everything works fine on my MySQL database." I thought the first two paragraphs were describing difficulties you were having loading data into a MySQL database. Please tell us more.