Jon, thanks for trying to help!
> Not much help I know, but you are not the only person having this problem. Okay, all you striving folks from MySQL on this list! When are you going to solve this? (The LOCAL feature is not essential to me, but it's a pain in the neck to encounter issues like this in MySQL :( 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: "Jon Bertsch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 11:19 PM Subject: Re: LOAD DATA LOCAL I posted the same question two weeks ago. The only suggestion was to add flags to the my.cnf file: [mysqld] local-infile=1 [mysql] local-infile=1 But this didn't work. I've tried using the flags on startup of MySQL as shown in the manual but this fails as well. We were running 3.23.49. I then upgraded to 3.23.54a which appears to have the command turned on when compiled - the configure line says --enable load data local - but it doesn't work for this version either (on my system). I wrote a work around script to allow upload of the file through a form on the web server and then ftp it to my database server. I can then use LOAD DATA without the local to insert the data. This works but you have to have the correct permissions set on the directory that the file is FTP'd into. So if you can get the file to the correct server then just avoid the local part of the clause and give the path to the file while running the command line or SQL. Of course this approach recreates the security hole but my scripts are all behind login pages anyway. Not much help I know, but you are not the only person having this problem. Jon Bertsch At 09:38 PM 1/3/2003 +0100, you wrote: >Hi, > >(I posted this question once before in a Re: that everyone seems to have >missed ;-) > >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 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 in spite of this >"improvement"? > >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 > > > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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