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:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 6:32 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] -- 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
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:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 6:32 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] -- 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
Re: [PHP-DB] [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 [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 6:32 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] [Import text file]
On Friday 14 February 2003 00:29, karthikeyan.balasubramanian wrote: This LIST need some change :). Your email client needs changing :) Generally we just say reply and give our suggestions. This works in other list. The 'other' list is broken. This one goes only to the person who posed the question. Real email clients gives you multiple response methods -- reply to sender; reply to list; reply to all; bounce; redirect etc -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Drinking is not a spectator sport. -- Jim Brosnan */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 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 : Apache 1.3.17 win32 PHP 4.0.5-dev MySQL client API version 3.23.32 An idea ?? RG [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php