Andrew,
Tuesday, August 27, 2002, 4:21:29 AM, you wrote:

>>Stuart Low wrote:
>> > Have had continuing issues with trying to actually get LOAD LOCAL INFILE
>> > commands working....


>>At 11:45 26/08/02 +0300, Victoria Reznichenko wrote:
>>Did you specified local-infile=1 for client, too?


AM> Hi,

AM> I'm a MySQL newbie and I've got a question on this too.

AM> I can't get MySQL to load a txt file, I'm using the latest Windows version.

AM> This may be a dumb question, but where exactly do I enter the 
AM> local-infile=1 command?

AM> Do I add it into the my.ini file or does this have to be entered every time 
AM> I start MySQL?

You can do it both ways.
If you want to specify local-infile=1 in my.cnf/my.ini file you can
add this entry in the sections [mysqld] and [mysql] (if you use mysql
command-line client)

[mysqld]
local-infile=1

[mysql]
local-infile=1

Or you can run mysqld and client with --local-infile=1 option.




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to