Terence, Rich, > > I have tried: > > LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE lcopen; > > but it shows: > > ERROR 1148: The used command is not allowed with this > > MySQL version
This is because of security issues, as the manual says: In MySQL 3.23.49 and MySQL 4.0.2, we added some new options to deal with possible security issues when it comes to LOAD DATA LOCAL. [snip] If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, unless one calls mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0) in the client. [snip] For the mysql command-line client, LOAD DATA LOCAL can be enabled by specifying the option -- local-infile[=1], or disabled with --local-infile=0. Full text: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD DATA LOCAL (keep getting error 1148). I tried: - Starting the server with --local-infile=1, and once more with --local-infile. - Starting the mysql client with --local-infile[=1] - Combining server and client options The manual page on this is quite contradictory. I agree with the user comment on that manual page: I just wasted 3 hours of my time tracking down this annoying security "improvement" -- thanks but no thanks, MySQL developers. This was poorly thought out and poorly implemented. Any hints how to make LOAD DATA LOCAL work? 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: "rich allen" <[EMAIL PROTECTED]> To: "Terence Ng" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 01, 2003 6:23 AM Subject: Re: load data local infile > sound like you may want to add the following to your my.cnf file for > MySQL > > [mysqld] > local-infile=1 > > [mysql] > local-infile=1 > > - hcir > > > On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote: > > > Hi, > > > > I have just upgraded to 3.23.54 > > > > How to input bulk data into table? > > > > I have tried: > > LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE > > lcopen; > > > > but it shows: > > ERROR 1148: The used command is not allowed with this > > MySQL version > > > > How come? What method can I use to input bulk data? > > > --------------------------------------------------------------------- > 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