Hi Mauricio,
On Wed, Feb 18, 2009 at 12:58 AM, Mauricio Tellez
mauricio.tel...@gmail.com wrote:
Hi, sorry if this is an offtopic. I have a web site with LAMP, one module
use a LOAD DATA LOCAL INFILE statement, all was running fine, but today I
ran this module and I get an The used command is not allowed with this
MySQL version message. If I use the same query from mysql command line I
get the same message, so I put the following in my.cnf: loose-local-infile
at [client]section. This solve the mysql command line, but when running from
PHP I still got the same. Any clue?
I think you need to either start the server with
--local-infile[={0|1}]
If you start the server with --local-infile=0, clients cannot use
LOCAL in LOAD DATA statements. See Section 5.3.4, Security Issues
with LOAD DATA LOCAL.
http://dev.mysql.com/doc/refman/5.0/en/privileges-options.html#option_mysqld_local-infile
Or set the variable globally in the running instance.
local_infile
Variable Name local_infile
Variable Scope Global
Dynamic VariableYes
Whether LOCAL is supported for LOAD DATA INFILE statements. See
Section 5.3.4, Security Issues with LOAD DATA LOCAL.
Understanding the implications.
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Cheers,
Ewen
--
Mauricio Tellez
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org