The used command is not allowed with this MySQL version

thomasp

I am trying to insert values into a mysql database from a csv or text file and I get the following error message:

'The used command is not allowed with this MySQL version '

I have checked the status of 'local-infile' , which is on.

Any other reason could occur this problem? and how to resolve?

Your help would be greatly appreciated.

thomas

steadyguy

What command are you trying use? Or ... what does your SQL look like?

thomasp

I found another strange case:

It says,
"SQL-query :

LOAD DATA LOCAL NFILE 'C:\Web\PHP\uploadtemp\php1.tmp' INTO TABLE
...."

While the file I try to load is not "php1.tmp", the path is also wrong.

When trying another time, It almost shows the same words, just changes
the
file name "php1.tmp" to "php2.tmp".

The number will continue to increase if you continue to load for
another
time.

Any idea to fix this problem??

Thanks in advance!

bjoerndalen

Hi there Thomas...

I just started playing yesterday with MySQl and I had the same problem.

I finally managed to get it to work. I'm not sure if this will help but give it a go and see what happens....

I used notepad to create a text file with my values in. Make sure all the info for each value is on the same line and I used the tab key between each field.

Save this file as something.txt

I then used this
LOAD DATA INFILE "C:\filepath\something.txt" INTO TABLE tablename

Hope it helps I'm afraid its a bit like the blind leading the blind.🆒 😃

Good luck Dave....Let me know how you get on.

steadyguy

As for the .tmp file ... that's ok, what happened is that you just uploaded your file in php, and it is storing it temporarily on the same server for easy access from the database.

thomasp

Hi, steadyguy

then could you give any advice on how to resolve the problem?

Thanks.

steadyguy

The method that bjoerndalen suggested above should work ... did you try it?

thomasp

Thanks.

That way really works.

I wonder whether there is any other way to resolve this bug...