Re: [Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]]
I tried putting --local-infile in my server script and local-infile in the /etc/my.cnf file. I also placed a number or logging cammands in the startup script hoping to catch lower level messages. There appears to be little effect on anything. Regards, Tom Birchmire < -- script and log stuff Startup Script using --local-infile #! /bin/sh cd /usr/local/mysql/ ./bin/safe_mysqld --user=mysql --local-infile --warnings --log-long-format & MYSQL Session with error mysql> select * from pet -> ; +--++-+--++---+ | name | owner | species | sex | birth | death | +--++-+--++---+ | Puffball | Diane | hamster | f| 1999-03-30 | NULL | | Fluffy | Harold | cat | f| 1993-02-04 | NULL | +--++-+--++---+ 2 rows in set (0.03 sec) mysql> load data local infile "/home/tomb01/data/pet.txt" into table pet; ERROR 1148: The used command is not allowed with this MySQL version mysql> quit Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: > Thomas Birchmire writes: > > I have the same problem using Linux RedHat 7.2. Just what do I have to > > configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on > > i686? > > The rest of MySQL works as advertised. > > Regards Tom Birchmire > > > > > > loca-infile is not a variable. > > Therefore, you either start a server with --local-infile or have in > your /etc/my.cnf : > > [mysqld] > local-infile > > -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]
I have the same problem using Linux RedHat 7.2. Just what do I have to configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on i686? The rest of MySQL works as advertised. Regards Tom Birchmire Michael Widenius <[EMAIL PROTECTED]> wrote: > > Hi! > > > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > Sinisa> [EMAIL PROTECTED] writes: > >> >Description: > >> LOAD DATA LOCAL INFILE ... > >> > >> leads to 'The used command is not allowed with this MySQL version' > >> > >> This happens regardless of whether I have a > >> > >> local-infile = 1 > >> > >> in my /etc/my.cnf. In neither case does the local-infile variable show > >> up with SHOW VARIABLES. > > We don't have a status variable that shows if this feature is enabled > or not. > > The above is quite strange as I did test this properly before doing a > release. > > Did you give the above option to both 'mysqld' and 'mysql' ? > > Which MySQL distribution are you using ? > > Sinisa> Hi! > > Sinisa> A new startup variable : > > Sinisa> --local-infile > > Sinisa> must be used to enable the above feature. > > That is what the user described that he did do... > > Regards, > Monty > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
load data local - strange message. ERROR 1148
I installed mysql-3.23.49a on my redhat 7.2 machine with the binary. While working throught the tutorial I was attempting to do: load data local infile "/home/tomb01/data/pet.txt" into table pet; and got: ERROR 1148: The used command is not allowed with this MySQL version What is the real meaning here? All the other commands and things appear to work. Thanks Tom B - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php