if, while you are trying to load data, you receive the following error:
Error Code: 1148. The used command is not allowed with this MySQL version
you should perform the following steps:
1. Open terminal
By pressing ctrl+alt+T or any other way.
2. Login to mysql with –local-infile flag set
mysql -uroot -p --local-infile
3. Execute LOAD DATA LOCAL command.
Beware that you need to have read access to the file you want to import.
Then, execute the command as normal, eg:
LOAD DATA LOCAL INFILE '/blabla/data.csv' INTO TABLE YOURTABLE FIELDS TERMINATED BY '|' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;
You can also look at this great troubleshooting article.