Page 1 of 1

The used command is not allowed with this MySQL version

Posted: Wed Feb 12, 2003 5:23 am
by jarow
I am trying to insert values into a mysql database from a csv or text file using the LOAD DATA LOCAL command and I get the following error message:

The used command is not allowed with this MySQL version

I read 4.2.4 Security issues with LOAD DATA LOCAL in mysql.com and understand that I have to configure mysql with --local-infile=1

That´s what I don´t understand...where do I do this exactly.

I typed in the following at the prompt:

C:\mysql\bin: mysqld --local-infile=1

and I get no response (normally another prompt would appear after which I type mysql.exe and I enter into mysql land)

I also have phpmyadmin and winmysqladmin...but cannot find with either of these to configure mysql.

Your help would be greatly appreciated.

Jim

Posted: Wed Feb 12, 2003 8:48 pm
by redcircle
you would have to compile mysql and not use the binary dist.