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