ID: 7244
Comment by: neron_cl at yahoo dot com
Reported By: c dot schmidt-koester at gmx dot net
Status: No Feedback
Bug Type: MySQL related
Operating System: win 98
PHP Version: 4.1.0
New Comment:
I had the same problem, and this works me:
LOAD DATA LOCAL INFILE "c:/MYSQL/file.txt" INTO TABLE $table FIELDS
TERMINATED BY ';'
Previous Comments:
------------------------------------------------------------------------
[2002-10-18 23:53:01] manteau at grafix dot nl
I am having a problem wich is likewise I think
Loading data from a windows host to a linux server
echo "<input type=\"hidden\" name=\"file1\"
value=\"D:\gegevens.txt\">";
$file1 = str_replace("\\" , "\\\\", $file1);
$result=mysql_query ("LOAD DATA LOCAL INFILE '$file1' INTO TABLE agenda
(plaats, activiteit)");
returns this: File 'D:\\gegevens.txt' not found (Errcode: 2)
If I do the same on the mysql server wich runs on windows at home and
type in the mysql monitor:
load data local infile 'D:\\gegevens.txt' into table agenda;
everything works fine.
So the location with the extra backslash should work....
I spend a lot of time on this and tried about everything and can't
figure it out.
------------------------------------------------------------------------
[2002-07-18 01:00:08] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2002-06-17 16:04:02] [EMAIL PROTECTED]
Rather try the latest CVS snapshot build:
http://snaps.php.net/win32/php4-win32-latest.zip
------------------------------------------------------------------------
[2002-06-17 13:35:57] [EMAIL PROTECTED]
Is this still a problem with PHP 4.2.1?
Derick
------------------------------------------------------------------------
[2002-01-14 22:00:42] [EMAIL PROTECTED]
Please update PHP Version if you've tested with newer version :)
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/7244
--
Edit this bug report at http://bugs.php.net/?id=7244&edit=1
