load data in php

------=_NextPart_000_0016_01CB0174.92328690
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,

=20

I have the following script:

Load data

Local infile =91myData.csv=92

Into table myTable

Fields terminated by =91,=92

Enclosed by ‘’

Lines terminated by =91\r\n=92

(field1, field2, =85)

=20

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

=20

Any help on this?

=20

Thanks,

=20

Memo Garc=EDa 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=20

=20


------=_NextPart_000_0016_01CB0174.92328690--

Re: load data in php

--0050450142e8dd44a90487f8ddfa
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

If you are using v4 of php this will never work

On Tue, Jun 1, 2010 at 10:24 AM, memo garcia 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 ‘’
>
> 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 Fax: 56-2-2051029
>
> www.cisconsultores.cl
>
>
>
>

--0050450142e8dd44a90487f8ddfa--

RE: load data in php

------=_NextPart_000_0020_01CB017B.2FEBF870
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Nike,

=20

I=92m using

PHP 5.2.3 with Suhosin-Patch 0.9.7 (cli) (built: May 7 2010 08:41:40)

=20

Thanks,

=20

Memo Garc=EDa 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=20

_____ =20

De: Mike [mailto:hijinks@gmail.com]=20
Enviado el: Tuesday, June 01, 2010 10:34 AM
Para: mgarcia@cistrans.cl
CC: mysql@lists.mysql.com
Asunto: Re: load data in php

=20

If you are using v4 of php this will never work

On Tue, Jun 1, 2010 at 10:24 AM, memo garcia =
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 ‘’

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 Fax: 56-2-2051029

www.cisconsultores.cl




=20


------=_NextPart_000_0020_01CB017B.2FEBF870--

Re: load data in php

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 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@gmail.com]
> Enviado el: Tuesday, June 01, 2010 10:34 AM
> Para: mgarcia@cistrans.cl
> CC: mysql@lists.mysql.com
> 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 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 ‘’
>
> 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@gmail.com

May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg