#7244 [Com]: Problem with LOAD DATA LOCAL INFILE

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] sniper@php.net Rather try the latest CVS snapshot build: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-06-17 13:35:57] derick@php.net Is this still a problem with PHP 4.2.1? Derick ------------------------------------------------------------------------ [2002-01-14 22:00:42] yohgaki@php.net 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