List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:June 1 2010 4:54pm
Subject:Re: load data in php
View as plain text  
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.
Thread
load data in phpmemo garcia1 Jun
  • Re: load data in phpMike1 Jun
    • RE: load data in phpmemo garcia1 Jun
      • Re: load data in phpMichael Dykman1 Jun