[Shaky2]

Hi,

Can anyone help?

I'm having a problem with MySQL and the Load Data Infile command on my CPanel server, I need to run an import routine and will not work on my server.

I have tried lots of different ways, but whatever way I start MySQL with the local-infile=1 switch set it's being ignored by MySQL.

I looked at the MySQL documentation for more information on Load Data Infile, http://www.mysql.com/doc/en/LOAD_DATA.html,
but still not working.

Anyone else have similar problem?

I'm even looking at the possibility that someone out there has written the functionality of the load data infile command in a php script?

[Shaky2]

I got the DB problem working by looking at this forum:

http://www.dbforums.com/showthread.p...ad+Data+Infile

Originally Posted by Shaky2

Hi,

Can anyone help?

I'm having a problem with MySQL and the Load Data Infile command on my CPanel server, I need to run an import routine and will not work on my server.

I have tried lots of different ways, but whatever way I start MySQL with the local-infile=1 switch set it's being ignored by MySQL.

I looked at the MySQL documentation for more information on Load Data Infile, http://www.mysql.com/doc/en/LOAD_DATA.html,
but still not working.

Anyone else have similar problem?

I'm even looking at the possibility that someone out there has written the functionality of the load data infile command in a php script?