Egor, >> 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.
> You should set this variable for the server, too. > [mysqld] > local-infile=1 When I start the server with --local-infile=1 (actually, it's in my my.ini as you described), and I start the client with the same option, I get this: C:\mysql\bin>mysql test --local-infile=1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.0.10-gamma-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> load data local infile 'c:/test.txt' into table umlaut; ERROR 1148: The used command is not allowed with this MySQL version mysql> SHOW VARIABLES LIKE 'local%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | ON | +---------------+-------+ This is not the documented behaviour. So is it a bug? Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] --------------------------------------------------------------------- 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