This sounds like a matter to take up with whoever supports the
particular PHP/MySQL interface you are using.
Are you using the mysql, mysqli or dbo? The restriction very likely
originates from that layer.
- michael dykman
On Tue, Jun 1, 2010 at 11:11 AM, memo garcia <mgarcia@stripped> wrote:
> Nike,
>
>
>
> I’m using
>
> PHP 5.2.3 with Suhosin-Patch 0.9.7 (cli) (built: May 7 2010 08:41:40)
>
>
>
> Thanks,
>
>
>
> Memo García Sir
>
> CIS Asociados Consultores en Transporte S.A.
>
> Austria 2042 Providencia
>
> Santiago de Chile
>
> F: 56-2- 2051033 Fax: 56-2-2051029
>
> www.cisconsultores.cl
>
> _____
>
> De: Mike [mailto:hijinks@stripped]
> Enviado el: Tuesday, June 01, 2010 10:34 AM
> Para: mgarcia@stripped
> CC: mysql@stripped
> Asunto: Re: load data in php
>
>
>
> If you are using v4 of php this will never work
>
> On Tue, Jun 1, 2010 at 10:24 AM, memo garcia <mgarcia@stripped> wrote:
>
> Hi all,
>
>
>
> I have the following script:
>
> Load data
>
> Local infile ‘myData.csv’
>
> Into table myTable
>
> Fields terminated by ‘,’
>
> Enclosed by ‘’
>
> Lines terminated by ‘\r\n’
>
> (field1, field2, …)
>
>
>
> When this is sourced directly from mysql it works fine, but when invoked
> from php, I get the error
>
> The used command is no allowed with this MySQL version
>
>
>
> Any help on this?
>
>
>
> Thanks,
>
>
>
> Memo García Sir
>
> CIS Asociados Consultores en Transporte S.A.
>
> Austria 2042 Providencia
>
> Santiago de Chile
>
> F: 56-2- 2051033 Fax: 56-2-2051029
>
> www.cisconsultores.cl
>
>
>
>
>
>
>
--
- michael dykman
- mdykman@stripped
May the Source be with you.
