The used command is not allowed with this MySQL version

[chadrt]

I am not very proficient at MySQL so this came as a shock today.  I have moved an entire set of scripts from one machine to another and after ironing out some of the kinks I was hit this error "The used command is not allowed with this MySQL version" and just when I thought it was all over with.  LOL

 

This is the command being run...

 

load data local infile './AM.dat' into table AM fields terminated by '|';

[chadrt]

Solved!  I had to enable local-infile in the my.cnf

[CroNiX]

You'd have to check the version of MySQL that your new server is using and use something appropriate for that version.

[chadrt]

I have "mysql  Ver 14.14 Distrib 5.5.41, for debian-linux-gnu (x86_64) using readline 6.2" I am lucky in a sense that I have complete control over the server as I have root priviledges.  If I were trying to run this on a shared hosting env I might very well have to use a different command.  From what I have read it is security issue on shared env's so it disabled by default.