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. 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... 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. 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? 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 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
Archived
This topic is now archived and is closed to further replies.