Bug #55737 [Asn->Fbk]: LOAD DATA LOCAL INFILE - The used command is not allowed with this MySQL versio

From: Date: Fri, 21 Oct 2011 11:20:24 +0000
Subject: Bug #55737 [Asn->Fbk]: LOAD DATA LOCAL INFILE - The used command is not allowed with this MySQL versio
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-164489@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=55737&edit=1

 ID:                 55737
 Updated by:         andrey@php.net
 Reported by:        stefan dot kaifer at hartmann dot info
 Summary:            LOAD DATA LOCAL INFILE - The used command is not
                     allowed with this MySQL versio
-Status:             Assigned
+Status:             Feedback
 Type:               Bug
 Package:            MySQL related
 Operating System:   opensuse 11.0
 PHP Version:        5.3.8
 Assigned To:        mysql
 Block user comment: N
 Private report:     N

 New Comment:

Can you try 5.3-svn? Altough the NEWS entry mentions 5.4 the fix has landed in 5.3 too (committed on
Sep 2). 5.3.8 was released on Aug 23rd.


Previous Comments:
------------------------------------------------------------------------
[2011-10-20 13:29:11] richardpq at gmail dot com

"Some bug fix is planned for PHP 5.4", what is that mean? no solution for php 
5.3?

I would prefer a solution for this version, rather than wait for the final 
release of the new version, testing and see if it not affect others thing.

------------------------------------------------------------------------
[2011-10-20 13:07:17] stefan dot kaifer at hartmann dot info

Thanx, it's very good!

------------------------------------------------------------------------
[2011-10-20 12:57:34] denis_truffaut at hotmail dot com

Some bug fix is planned for PHP 5.4 :

http://php.net/releases/NEWS_5_4_0_beta1.txt

- PDO MySQL driver:
  . Fixed bug #54158 (MYSQLND+PDO MySQL requires #define MYSQL_OPT_LOCAL_INFILE)
  (Andrey)

------------------------------------------------------------------------
[2011-10-19 02:30:15] richardpq at gmail dot com

No, I dont have enable, my php.ini:

; open_basedir, if set, limits all file operations to the defined directory
; and below.  This directive makes most sense if used in a per-directory
; or per-virtualhost web server configuration file. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
; http://php.net/open-basedir
;open_basedir =

Also has the first guy said... I can use LOAD DATA LOCAL INFILE, from MySql 
client but not from an application using PHP.

------------------------------------------------------------------------
[2011-10-18 20:23:34] andrey@php.net

mysqlnd allows LOAD DATA LOCAL in all cases but
if open_basedir is enabled. If open_basedir is set it is disabled regardless where the file to be
loaded resides. This might be too strict for shared envs.
Do you have open_basedir enabled?

------------------------------------------------------------------------


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

    https://bugs.php.net/bug.php?id=55737


-- 
Edit this bug report at https://bugs.php.net/bug.php?id=55737&edit=1

Thread (25 messages)

« previous php.bugs (#164489) next »