Re: Load Data Local Infile - Rony Koting - com.mysql.lists.mysql

9 messages in com.mysql.lists.mysqlRe: Load Data Local Infile

From	Sent On	Attachments
Bill Doerrfeld	04 Jun 2003 15:29
Nils Valentin	04 Jun 2003 18:16
John May	08 Jun 2003 12:16
Rony Koting	08 Jun 2003 12:51
John May	08 Jun 2003 13:26
John May	08 Jun 2003 13:31
Mark Matthews	08 Jun 2003 13:49
Rony Koting	08 Jun 2003 14:16
John May	08 Jun 2003 14:41

Subject:	Re: Load Data Local Infile
From:	Rony Koting (scri...@hotmail.com)
Date:	06/08/2003 12:51:46 PM
List:	com.mysql.lists.mysql

If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, unless one calls mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0) in the client

Read the mysql manual from msyql.com about 'manual_MySQL_Database_Administration.html#LOAD_DATA_LOCAL'

Regards,

OK, tearing my hair out here...

I am trying to get a LOAD DATA LOCAL INFILE command to work. It works when I start the MySQL client with "--local-infile=1", but never in any other situation. Starting without this option, or submitting the request through PHP or Lasso results in the "command isn't supported" error.

I have tried a million different my.cnf changes, but no luck.

Is there any way to tell MySQL to default to allowing LOAD DATA LOCAL INFILE instead of having to specify it in the client login? I'm trying this with both version 3.23.51 and 4.0.12-max.

The even odder thing is that I can get it to work fine on another machine running the pre-built 3.23.51 binary from entropy.ch. AND, if I move that build to the 3.23.51 hand-built machine, the error returns.

Any ideas GREATLY appreciated. Thanks!

- John

------------------------------------------------------------------- John May : President <http://www.pointinspace.com> Point In Space Internet Solutions jm...@pointinspace.com

LPA Corporate Partner / FSA Associate / ACN Member

Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available!