From: Michael Dykman
Date: June 1 2010 4:54pm
Subject: Re: load data in php
List-Archive: http://lists.mysql.com/mysql/221774
Message-Id: <AANLkTinGvPCjUwiJhqiKjgC6mJS1PdJCrgHwgN130xZ6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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=92m using
>
> PHP 5.2.3 with Suhosin-Patch 0.9.7 (cli) (built: May 7 2010 08:41:40)
>
>
>
> Thanks,
>
>
>
> Memo Garc=EDa Sir
>
> CIS Asociados Consultores en Transporte S.A.
>
> Austria 2042 Providencia
>
> Santiago de Chile
>
> F: 56-2- 2051033 =A0Fax: 56-2-2051029
>
> www.cisconsultores.cl
>
> =A0_____
>
> 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 =91myData.csv=92
>
> Into table myTable
>
> Fields terminated by =91,=92
>
> Enclosed by =91=92
>
> Lines terminated by =91\r\n=92
>
> (field1, field2, =85)
>
>
>
> 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=EDa Sir
>
> CIS Asociados Consultores en Transporte S.A.
>
> Austria 2042 Providencia
>
> Santiago de Chile
>
> F: 56-2- 2051033 =A0Fax: 56-2-2051029
>
> www.cisconsultores.cl
>
>
>
>
>
>
>



--=20
 - michael dykman
 - mdykman@stripped

 May the Source be with you.