Hi Mauricio,
On Wed, Feb 18, 2009 at 12:58 AM, Mauricio Tellez
<[email protected]> 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 Variable Yes
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/[email protected]
