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
The used command is not allowed with this MySQL version
Moderator: General Moderators