PDA

View Full Version : Load Data Infile Problem (MySQL)


shaky
03-26-2004, 10:26 PM
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?

shaky
03-26-2004, 11:48 PM
I got the DB problem working by looking at this forum:

http://www.dbforums.com/showthread.php?threadid=780550&highlight=Load+Data+Infile