yes he is right i am doing the same. and giving full path. i have other problems with load data infile :(
----- Original Message ----- From: "Frank Bax" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, June 08, 2005 1:39 AM Subject: Re: LOAD DATA INFILE - still confused > 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] > ___________________________________________________________ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
