NYCPHP Meetup

NYPHP.org

[nycphp-talk] LOAD DATA LOCAL INFILE

Hans Zaunere zaunere at yahoo.com
Sat May 17 21:43:48 EDT 2003


--- 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