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

ID: 7244 Comment by: manteau@grafix.nl Reported By: c.schmidt-koester@gmx.net Status: No Feedback Bug Type: MySQL related Operating System: win 98 PHP Version: 4.1.0 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2002-07-18 01:00:08] php-bugs@lists.php.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 :) ------------------------------------------------------------------------ [2002-01-14 19:24:48] jmplus@yfolire.net Same problem with PHP 4.1.0, Apache 1.3.22 and MySQL 3.21.29a under Win 98. Action made with phpMyAdmin 2.2.2 and phpMyAdmin 2.0.3. ------------------------------------------------------------------------ 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