[opensuse] MySQL Load Data Local Infile problem
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@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (5)
-
Bob Williams
-
Cristian Rodríguez
-
David C. Rankin
-
Mike McMullin
-
Per Jessen