RE: load data in php

[memo garcia]

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:hiji...@gmail.com] 
Enviado el: Tuesday, June 01, 2010 10:34 AM
Para: mgar...@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 <mgar...@cistrans.cl> 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