Edit report at https://bugs.php.net/bug.php?id=55737&edit=1
ID: 55737
Comment by: richardpq at gmail dot com
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
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:
"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.
Previous Comments:
------------------------------------------------------------------------
[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] and...@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?
------------------------------------------------------------------------
[2011-10-18 16:27:34] denis_truffaut at hotmail dot com
Related bugs :
https://bugs.php.net/bug.php?id=46964
https://bugs.php.net/bug.php?id=54158
A PHP Dev said it was resolved in 5.3.6, but it came back.
As it is a very common usage of MySQL, especialy to save/import data, it had to
be fixed in priority.
The override PDO::MYSQL_ATTR_LOCAL_INFILE => 1 also doesn't not work.
What to do ?! :O
------------------------------------------------------------------------
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
