Re: [introduction - Import text file]
| From: | J.Veenhuijsen | Date: | Thu, 13 Feb 2003 08:51:10 +0000 |
| Subject: | Re: [introduction - Import text file] | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-18521@lists.php.net to get a copy of this message | ||
Try LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\TEMP\\phpC255.TMP'
Rg wrote:
Let me introduce myself : I write to this list from Corsica (the nearest of the farest french overseas territories), and I am a newbie in Php, for those who have'nt realized yet :) and my error is : I try to do an import text file into a mysql table with the php script provided with Manucorp Easyphp, but it does not work. The message is : <<Erreur requête SQL: LOAD DATA LOCAL INFILE 'C:\WINDOWS\TEMP\phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) MySQL a répondu:File 'c:windowstempphpc255.tmp' not found (Errcode:2)>> The path above seems to be incorrect, but i have not found where to modify it. Environment is : Win 98 SE Apache 1.3.17 win32 PHP 4.0.5-dev MySQL client API version 3.23.32 An idea ?? RG rg@infogere.com