NYCPHP Meetup

NYPHP.org

[nycphp-talk] LOAD DATA LOCAL INFILE

Peter Lehrer pl at eskimo.com
Sat May 17 23:17:03 EDT 2003


On Sat, 17 May 2003, Hans Zaunere wrote:

Got it to work. Thanks Hans.

Peter Lehrer

>
> --- Peter Lehrer <pl at eskimo.com> wrote:
> > I am using LOAD DATA LOCAL and I get this error message:
> >
> > mysql> LOAD DATA LOCAL INFILE "down.dat" INTO TABLE 1rc;
> > ERROR 1148: The used command is not allowed with this MySQL version
> >
> > The MySQL version is 3.23.49-log.
> > This error occurs both on Widnows 95 and RedHat 6.1.
> >
> > The MySQL manual says that the LOCAL option should work on versions
> > 3.22.15 and above so I don't know why it working on my version.
> >
> > Any help in getting LOAD DATA LOCAL to work would be great.
>
> There were security issues with this command because it would allow MySQL to
> potentially read any file (/etc/shadow for instance).
>
> http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
>
> H
>
> >
> > Peter Lehrer
> >
> >
> >
> >
> >
> >
>
>
>
> --- Unsubscribe at http://nyphp.org/list/ ---
>
>




More information about the talk mailing list