chadrt Posted February 3, 2015 Share Posted February 3, 2015 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 '|'; Quote Link to comment https://forums.phpfreaks.com/topic/294342-the-used-command-is-not-allowed-with-this-mysql-version/ Share on other sites More sharing options...
Solution chadrt Posted February 3, 2015 Author Solution Share Posted February 3, 2015 Solved! I had to enable local-infile in the my.cnf Quote Link to comment https://forums.phpfreaks.com/topic/294342-the-used-command-is-not-allowed-with-this-mysql-version/#findComment-1504748 Share on other sites More sharing options...
CroNiX Posted February 3, 2015 Share Posted February 3, 2015 You'd have to check the version of MySQL that your new server is using and use something appropriate for that version. Quote Link to comment https://forums.phpfreaks.com/topic/294342-the-used-command-is-not-allowed-with-this-mysql-version/#findComment-1504749 Share on other sites More sharing options...
chadrt Posted February 3, 2015 Author Share Posted February 3, 2015 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. Quote Link to comment https://forums.phpfreaks.com/topic/294342-the-used-command-is-not-allowed-with-this-mysql-version/#findComment-1504751 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.