Mailinglist Archive: opensuse (887 mails)

< Previous Next >
Re: [opensuse] MySQL Load Data Local Infile problem
On Thursday 27 Jan 2011 15:21:31 Per Jessen wrote:
Bob Williams wrote:
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

You probably need to start mysql with '--load-infile'.

Yes, I tried that,

mysql --load-infile -u root -p

but it's an 'unknown option' :(

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

< Previous Next >