Dirk, you're right. LOCAL is disabled by default with all newer versions of MySQL (server and client). One can enable LOCAL by _compiling_ MySQL with --enable-local-infile, but this is not possible for binaries, of course.
The manual says you can enable LOCAL with --local-infile=1, either for the server and/or for the mysql client. This doesn't work for me, though. I'm still waiting for an explanation by a guru/developer whether I am misunderstanding something, or if this is a bug, or even a feature. http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Dirk Hennrichs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 7:25 AM Subject: Error 1148 by remote mysql +execute +insert > I am using mysql 3.23.59. By using the command mysql -h Remote > --database=db -uuser -ppassword --execute "load data local infile > ......" I get error nr. 1148: "The used command is not allowed with this > MySQL Version". Before I used mysql 3.23.37 and the above command was > OK. I tested the --execute command with oder SQL Statements like select, > update, everything works fine. Only the load command seems to be > disabled. Has anybody an idea if the --execute and load infile tag can > be enabled with version 3.23.59. My fear is that any new updated version > does not allow this command, and I need it !!!!!!! ;-) > > Any hint ? > > Dirk Hennrichs > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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