Mailinglist Archive: opensuse (887 mails)

[Bob Williams <linux@xxxxxxxxxxxxxxxxxxxxx>]

To the database gurus

I've just started exploring mysql (I'm a db newbie), and run into a 'feature'.

When I do LOAD DATA LOCAL INFILE '/path/to/file.txt' INTO TABLE mytable;

I get Error 1148: The used command is not allowed with this MySQL version

I know that it's disabled for security reasons, but I don't want to have to 
enter each record individually. Is there a hack to get round this restriction, 
or do I have to recompile mysql?

Bob
-- 
Registered Linux User #463880           FSFE Member #1300
GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E
openSUSE 11.3 64-bit, Kernel 2.6.36.90-desktop, KDE 4.5.3
Intel Core2 Quad Q9400 2.66GHz, 8GB DDR RAM, nVidia GeForce 9600GT
-- 
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx