FW: [PHP-DB] [Import text file]

Just forwarding this on to the general list as it was only sent directly to me. -----Original Message----- From: karthikeyan.balasubramanian [mailto:karthikeyan.balasubramanian@aspiresys.com] Sent: Thursday, February 13, 2003 9:03 AM To: Hutchins, Richard Subject: Re: [PHP-DB] [Import text file] try using something like this C:\\WINDOWS\\TEMP\\PHPC255.TMP Hope this works. Have a great day. ----- Original Message ----- From: "Hutchins, Richard" <Richard.Hutchins@Getingeusa.com> To: <rg@infogere.com>; <php-db@lists.php.net> Sent: Thursday, February 13, 2003 6:41 PM Subject: RE: [PHP-DB] [Import text file] > > A quick trip through the MySQL manual hints that you may have to use forward > slashes in your path on a windows system. So... > > 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) > > ...might just do the trick (note the forward slashes in the path to the > file). > > Hope this helps. > > > -----Original Message----- > > From: RG [mailto:rg@infogere.com] > > Sent: Wednesday, February 12, 2003 6:32 PM > > To: php-db@lists.php.net > > Subject: [PHP-DB] [Import text file] > > > > > > Hi > > > > 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 > > requete 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 repondu: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 : > > > > Apache 1.3.17 win32 > > PHP 4.0.5-dev > > MySQL client API version 3.23.32 > > > > An idea ?? > > RG > > rg@infogere.com > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >