PDOException: SQLSTATE[42000]: 1148 The used command is not allowed with this MySQL version in AWS RDS

To Resolve this error you have to connect mysql with below command then you can able to run LOCAL INFILE command in mysql console or drupal.


# mysql --local-infile=1 -h rds-amazon-url.com -uroot -p


Now you can able to run LOCAL INFILE command in RDS.

#mysql>LOAD DATA LOCAL INFILE '/tmp/foo.txt' INTO TABLE foo
COLUMNS TERMINATED BY '\t';