Re: File location path while using LOAD_FILE

[Ben H.]

With,

LOAD DATA LOCAL INFILE "filename"

filename must be on the *mysql client* host.

With,

LOAD DATA INFILE "filename"

filename must be on the server and must be relative to the server datadir.

In other cases retreive the file differently, depends on your network you
might have ftp, scp, etc.

But, i can't see where you are perl specific in your question, as this forum
should be?



Edited 1 time(s). Last edit at 02/08/2008 04:10AM by Ben H..