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
