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]