PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE
| From: | c dot schmidt-koester at gmx dot net | Date: | Thu, 04 Jan 2001 15:41:56 +0000 |
| Subject: | PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-42938@lists.php.net to get a copy of this message | ||
ID: 7244
User Update by: c.schmidt-koester@gmx.net
Status: Open
Bug Type: MySQL related
Description: Problem with LOAD DATA LOCAL INFILE
With
$file = addslashes ($file);
it works.
Previous Comments:
---------------------------------------------------------------------------
[2000-10-16 10:51:25] c.schmidt-koester@gmx.net
I'm using Win98, Apache 1.3.9, MySQL 3.23-beta and PHP4.0.3.
Since PHP4.0.3 there is a problem with import data to MySQL (LOAD DATA LOCAL INFILE). It seems that
PHP is filtering out all slashes of the file path, so MySQL can't find the file.
mysql_error() and mysql_errno() say something like this
"File 'e:TempphpA154.TMP' not found (Errcode: 2)"
LOAD DATA INFILE (without LOCAL) seems to be ok.
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=7244