load data in php

[memo garcia]

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