Hi,

yes I did this .

here were some lines from my server-cfg file:
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=64
set-variable    = sort_buffer=512K
set-variable    = net_buffer_length=8K
set-variable    = myisam_sort_buffer_size=8M
server-id       = 1

skip-name-resolve
local-infile=1

Also if I ask the server with 'Show variables like 'loc%'' he says me
loc_infile=ON

So what's going wrong.

Best regards

> -----Original Message-----
> From: Egor Egorov [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 20, 2003 1:07 PM
> To:   [EMAIL PROTECTED]
> Subject:      re: Bug-Load data local infile
> 
> On Wednesday 19 February 2003 17:30, Guddack Thorsten ICM MP SCM GO 21
> wrote:
> 
> > I'm using 4.0.10-max-nt of mysql.
> >
> > I update to this version from 4.0.5. With this version I have no trouble
> > with load data local infile.
> >
> > But now if i try to use it from the mysql-Command-line tool i get
> > an errror 1148, This command is not allowed with this mysql version.
> >
> > On my server the variable local_infile is set to on.
> >
> > I change to my.cnf-File on my client to
> > [mysql]
> > local-infile=1
> >
> > or I try to start mysql with the option --local-infile.
> >
> > Everything gives me the same error.
> >
> > Any Ideas?
> 
> You should set this variable for the server, too.
> 
> [mysqld]
> local-infile=1
> 
> 
> 
> -- 
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Egor Egorov
>  / /|_/ / // /\ \/ /_/ / /__   [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