configuring is only be done on build time procedure. I supposed (not sure) that your problem is with your precompiled binary. I dont really know whether the default precompiled binary building with enable LOAD DATA or not. so , you can try install it with mysql source .(not precompile binary).
Regards. ROny ----- Original Message ----- From: "John May" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 09, 2003 3:31 AM Subject: Re: Load Data Local Infile > The other odd thing I find is that the MySQL manual states: > > > By default, all MySQL clients and libraries are compiled with > --enable-local-infile , to be compatible with MySQL 3.23.48 and > before. > > > However, I'm using a 4.0.12-max binary (pre-compiled binary direct > from MySQL's site) on one machine, and enable-local-infile is > definitely NOT compiled into it... > > Have others seen this case contrary to the documentation? > > - John > > > >Can this only be done at build time? Or can I enable it after the > >fact? If so, how? I tried enable-local-infile as both a setting in > >my.cnf and when calling safe_mysqld both with no luck. > > > >In the meantime, I've found that PHP apparently calls MySQL with the > >local-infile option on - once I downgraded to 4.2.2 from 4.3.0 that > >is. This at least helps things a bit. > > > > - John > > > > > >>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, > >>----- Original Message ----- > >>From: "John May" <[EMAIL PROTECTED]> > >>To: <[EMAIL PROTECTED]> > >>Sent: Monday, June 09, 2003 2:17 AM > >>Subject: Load Data Local Infile > >> > >> > >> > 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 [EMAIL PROTECTED] > > LPA Corporate Partner / FSA Associate / ACN Member > > Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available! > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
