Re: [Import text file]

This LIST need some change :). Generally we just say reply and give our suggestions. This works in other list. This one goes only to the person who posed the question. Have a great day. Karthikeyan B. ----- Original Message ----- From: "Hutchins, Richard" <Richard.Hutchins@Getingeusa.com> To: <php-db@lists.php.net> Sent: Thursday, February 13, 2003 7:59 PM Subject: 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 > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >