Re: AW: [PHP-DB] Re: Subject: LOAD DATA LOCAL INFILE

2004-08-16 Thread randy
This is a setting in MySQL that you have to explicitly turn on at compile time. --enable-local-infile Enable LOAD DATA LOCAL INFILE (default: disabled) I suspect that's what _might_ be happening. On Mon, 16 Aug 2004 15:33:37 +0200, Daniel Kradolfer <[EMAIL PROTECTED]> wrote: > mysql_error() sa

AW: [PHP-DB] Re: Subject: LOAD DATA LOCAL INFILE

2004-08-16 Thread Daniel Kradolfer
mysql_error() says: 1148:The used command is not allowed with this MySQL version The same Script worked fine before we updated PHP and MySQL. The query works at the mysql shell prompt. But here it is: LOAD DATA LOCAL INFILE '/[Path]/inc/../in/wbsuser.src' REPLACE INTO TABLE user fields terminated

[PHP-DB] Re: Subject: LOAD DATA LOCAL INFILE

2004-08-16 Thread Neil Smith [MVP, Digital media]
I often had trouble getting the syntaxt just right with PHP, it's easy to end up with the wrong number of slashes around the -lines terminated by "'"- parts of this. When you ran your query, what did mysql_error() say about it ? That would be a line you add directly after the line mysql_query($l