Mailinglist Archive: opensuse (887 mails)
| < Previous | Next > |
Re: [opensuse] MySQL Load Data Local Infile problem
- From: Bob Williams <linux@xxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 27 Jan 2011 15:39:13 +0000
- Message-id: <201101271539.13320.linux@barrowhillfarm.org.uk>
On Thursday 27 Jan 2011 15:21:31 Per Jessen wrote:
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
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 > |