Well, in fact I have read the documentation several times before posting this note.
My problem arises because I don't know what is meant by full file path. If you mean: 'http://www.mydomain.com/datafile.txt' that produces the error: Can't get stat of 'http:/www.mydomain.com/datafile.txt' (Errcode: 2) Also, using a php pre-defined variable such as $_SERVER['DOCUMENT_ROOT'] creates the same error. Oh, yes I do know about file permissions in the entire path. If I only knew how to find the path, life would be much easier. "Frank Bax" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > At 03:59 PM 6/7/05, Chris wrote: > > >I have a simple php script which runs the following query: > > > >LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS > >TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' > > > >which generates the error: > >File './mydabasename/datafile.txt' not found (Errcode: 2) > > > Didn't bother to read the manual did you? > http://dev.mysql.com/doc/mysql/en/load-data.html > >> file named as myfile.txt is read from the > >> database directory of the default database > > Specify the full path to your input file. Life will be much easier. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]