The used command is not allowed with this MySQL version

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jarow
Forum Commoner
Posts: 83
Joined: Tue Jan 28, 2003 2:58 am

The used command is not allowed with this MySQL version

Post 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
User avatar
redcircle
Forum Commoner
Posts: 43
Joined: Fri Jan 31, 2003 8:47 pm
Location: michigan, usa

Post by redcircle »

you would have to compile mysql and not use the binary dist.
Post Reply