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]
