Hi !

)-----Original Message----- )From: Mark Matthews [mailto:mmat...@thematthews.org] )Sent: Friday, August 17, 2001 3:54 PM )To: ve...@mysql.com )Cc: Monty; ja...@lists.mysql.com )Subject: Re: LOAD DATA under jdbc ) ) )Sorry, I'm a little bit confused as to how the server can read files on the )client, as the JDBC driver doesn't do any of this...Is the server actually )ignoring the "local" part of the command?

I did again a simple research on this with my laptop and desktop. Here is the observations:

I have the file "loaddata.txt" on the desktop in folder f:\myodbc\loaddata.txt, and I execute the JDBC sample from this desk top itself.

-- When I connect to the server running locally i.e. on the desktop itself, then the LOAD DATA local INFILE works by inserting the data from the file to the specified table.

-- When I connect to the remote server which is running on my laptop, and when I execute the sample, I get the error saying " file not found". Probably the server couldn't find the file on the server side m/c, as it doen't exists.

I think this is as expected only. But, am waiting for some one to comment on this, who know the exact behaviour?