Drewser33 Posted February 10, 2015 Share Posted February 10, 2015 Mysql version 5.5 Linux OS - Debian LOAD DATA LOCAL INFILE '/var/tmp/import.csv' INTO TABLE r_data FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS (first_name,last_name,a_number,a_id) Error: The used command is not allowed with this MySQL version I have tried this from the mysql command line, phpmyadmin, and a php script, all with the same error. I have changed the local_infile GLOBAL VARIABLE to ON and restarted the mysql service to no avail. There are a lot of ideas on this out there, but I can't seem to put it all together. I was able to run the version of LOAD DATA INFILE, if I placed the same CSV in the root mysql directory, so I know that the CSV information is valid. Thanks for any help. Quote Link to comment https://forums.phpfreaks.com/topic/294516-the-used-command-is-not-allowed-with-this-mysql-version/ Share on other sites More sharing options...
CroNiX Posted February 10, 2015 Share Posted February 10, 2015 I have no experience with that particular problem, but could it be that the mysql user doesn't have permission to the /var/tmp dir? Really just a guess... Quote Link to comment https://forums.phpfreaks.com/topic/294516-the-used-command-is-not-allowed-with-this-mysql-version/#findComment-1505393 Share on other sites More sharing options...
Drewser33 Posted February 11, 2015 Author Share Posted February 11, 2015 I tried doing a chmod 777 on that directory, but the problem still exists. Quote Link to comment https://forums.phpfreaks.com/topic/294516-the-used-command-is-not-allowed-with-this-mysql-version/#findComment-1505433 Share on other sites More sharing options...
mac_gyver Posted February 11, 2015 Share Posted February 11, 2015 I have changed the local_infile GLOBAL VARIABLE to ON how exactly did you make this change and have you checked, with a show variables query, that the database server shows that it actually got changed to an ON value? Quote Link to comment https://forums.phpfreaks.com/topic/294516-the-used-command-is-not-allowed-with-this-mysql-version/#findComment-1505435 Share on other sites More sharing options...
Drewser33 Posted February 11, 2015 Author Share Posted February 11, 2015 Yes, VARIABLE NAME - LOCAL_INFILE, VARIABLE_VALUE - ON Quote Link to comment https://forums.phpfreaks.com/topic/294516-the-used-command-is-not-allowed-with-this-mysql-version/#findComment-1505439 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.