Charles, >> I posted the same problem a couple of days ago. LOCAL will not work >> because of a security "improvement" the MySQL folks applied.
> LOAD DATA INFILE "C:\\mysql\\fred.txt" INTO TABLE data_table; > Hope this helps, but only a workaround... Without LOCAL, quite alot of things will not work. Imagine an ISP giving every customer write privileges for the mysql/bin directory ... ;-/ Unfortunately, Monty did'nt mention if this is fixed in 4.0.8 or going to be fixed in 4.0.9 or 4.1. Personally, I regard this security "improvement" rather a bug than a feature. 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: "Charles Mabbott" <[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "'Prathmesh J. Mahidharia'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 3:04 AM Subject: RE: Load local data infile problem What I did was setup my file in mysql directory (i.e. fred.txt) LOAD DATA INFILE "C:\\mysql\\fred.txt" INTO TABLE data_table; Hope this helps, but only a workaround... Chuck http://68.43.100.7:81/aa8vs ========================================== "Patriotism is the willingness to kill and be killed for trivial reasons." - Bertran Russell -----Original Message----- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 3:59 PM To: Prathmesh J. Mahidharia; [EMAIL PROTECTED] Subject: Re: Load local data infile problem Prathmesh, > I have just installed mysql and am facing problems with the > Load data local infile problem. I went through the manual and did > all that was said like including the command > "--enable-local-infile" and "--local-infile[=1]", but it does not > seem to work. I posted the same problem a couple of days ago. LOCAL will not work because of a security "improvement" the MySQL folks applied. As far as I could figure out, the only way to solve this issue is to grab a source distribution and compile MySQL with --enable-local-infile. All the command line options the manual describes do not work at all! I wonder if - finally and hopefully - someone from MySQL will reply to the LOCAL problem mails, and tell us what to do (maybe there's a workaround), or when the problem will be solved. 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: "Prathmesh J. Mahidharia" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 5:22 AM Subject: Load local data infile problem > hello there, > I have just installed mysql and am facing problems with the > Load data local infile problem. I went through the manual and did > all that was said like including the command > "--enable-local-infile" and "--local-infile[=1]", but it does not > seem to work. I have the version 4.0.6-gamma-max-nt. If u could > plz, help me out with that, that would be very nice of u! I m > developing a project at the moment and have got to make large > entries into mysql tables, but this command is not working > properly and i m stuck! Could u plz help me out with that..? > Thank u in advance. > > Regards: > Prathmesh Mahidharia > > > > PRATHMESH J. MAHIDHARIA > B.E. (Electrical) > M.Sc.Information Technology (Murdoch Uni, Australia) > Phone no: (+61) 0421167375 > > > --------------------------------------------------------------------- > 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