Egor,

>> Any hints how to make LOAD DATA LOCAL work in spite of this
>> "improvement"?

> Stefan, currently I have no Windows box on hands, to check it out on
Win32, but I
> remember that it works for me at least on 4.0.6 with local-infile=1 in
> my.cnf.

as far as I remember from MySQL trainings in the last two months, LOCAL
worked with 4.0.3 and 4.0.4 on Win32, and with 3.23.52 on SuSE Linux
8.1.

Once again: This security "improvement" is a pain in the neck, or as
stated with the user comments on the appropriate manual page:

>>> This was poorly thought out and poorly implemented.

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: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 2:07 PM
Subject: re: LOAD DATA LOCAL


> On Friday 03 January 2003 22:38, Stefan Hinz wrote:
>
> > 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"?
>
> Stefan, currently I have no Windows box on hands, to check it out on
Win32, but I
> remember that it works for me at least on 4.0.6 with local-infile=1 in
> my.cnf.
>
> It also works like a charm on my Linux box on 4.0.7:
>
> mysql> LOAD DATA LOCAL '/tmp/a.sql' INTO TABLE a;
> Query OK, 3 rows affected (0.01 sec)
> Records: 3  Deleted: 0  Skipped: 0  Warnings: 0
>
>
>
> --
> For technical support contracts, goto
https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Egor Egorov
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
>
>
>
>
> ---------------------------------------------------------------------
> 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

Reply via email to