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) The simple php script and the file, datafile.txt are both in the same directory. Where is MySQL looking for the file, datafile.txt? NOTE: the error reported indicates that MySQL is searching in for datafile.txt in a directory called mydatbasename. However, I am running the php script in a shared hosting environment and I am not able to view the directory mydatbasename (if it is actually a directory). Apparently the directory is outside my root? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
