Edit report at https://bugs.php.net/bug.php?id=55737&edit=1
ID: 55737
Comment by: walkleyn 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: Not a bug
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:
Hi
The LOAD DATA LOCAL INFILE function does not work with mysql5.5 and php5.4.4 on Debian Wheezy with
open_basedir restrictions in place.
It works perfectly fine when open_basedir is disabled or set to nothing.
So I guess I'm following on from what Andrey has posted: "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?"
Indeed it is too strict for shared environments.
Is there any way to get around it?
I've tested it with the mysql lib (php5-mysql) as well as the mysqlnd drivers and both do the
same.
thanks
Walter
Previous Comments:
------------------------------------------------------------------------
[2013-10-01 14:28:07] wces77 at gmail dot com
Hi,
You'll need to modify apparmor's config file. And remove the 'local' word from
your sentence.
See this.
http://stackoverflow.com/questions/4215231/mysql-load-data-infile-error-code-13
You need to add the path you want to import from...
------------------------------------------------------------------------
[2013-10-01 06:15:23] sasaloginov at gmail dot com
The prolem is remains
PHP 5.5.4-1+debphp.org~raring+1 (cli) (built: Sep 27 2013 11:40:37)
Mysql: 5.5.32-0ubuntu0.13.04.1
------------------------------------------------------------------------
[2013-08-19 15:34:45] shag134 at hotmail dot com
Same here, bug still exists
PHP 5.4.9-4ubuntu2.2 (cli) (built: Jul 15 2013 18:23:35)
------------------------------------------------------------------------
[2013-05-20 19:54:27] sward at undergroundelephant dot com
This bug still exists and is affecting me on these versions:
PHP 5.4.6-1ubuntu1.1 (cli) (built: Nov 15 2012 01:18:34)
PHP 5.4.9-4ubuntu2 (cli) (built: Mar 11 2013 16:05:09)
Please remove the "not a bug" status and reopen this ticket. The issue is *not*
external. The problem has something to do with the PDO driver.
------------------------------------------------------------------------
[2013-05-14 08:49:16] dimm-man at yandex dot ru
In Debian Wheezy amd64 (PHP 5.4), this problem has not been solved. "LOAD DATA LOCAL
INFILE" a PDO does not work.
------------------------------------------------------------------------
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