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
