469,090 Members | 1,196 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Problems with local-infile Option

Hello,

Im using mysql 3.23.58 and I want to enable the local-infile option.
The manual on dev.mysql.com says the following to that:

.....
If you use LOAD DATA LOCAL in Perl scripts or other programs that read
the [client] group from option files, you can add the local-infile=1
option to that group. However, to keep this from causing problems for
programs that do not understand local-infile, specify it using the
loose- prefix:

[client]
loose-local-infile=1
......
But when I do that the I can restart the mysql-Server but starting of
mysqladmin says the following:

Unrecognized option local-infile
The same message with loose-local-infile=1.

When I start the server with --local-infile=1 and then starting the
mysql-Client with --local-infile=1 on the shell everything is OK and I
can use the LOAD DATA LOCAL Syntax.
What is wrong? Why it is an unregognized command? I need the LOAD DATA
LOCAL because I want to use mysql with Perl.
I hope somebody can help me.

Steffen
Jul 20 '05 #1
0 1092

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Darren Gamble | last post: by
6 posts views Thread by Andres Rosado-Sepulveda | last post: by
2 posts views Thread by Skip Montanaro | last post: by
reply views Thread by Richard Taylor | last post: by
2 posts views Thread by Adam Witney | last post: by
1 post views Thread by J. Jeffrey Close | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.