OR 1148 (42000): The used command is not allowed with this MySQL version

[Rajiv Chaturvedi]

Hi,

Does anyone get this error when loading a csv file into a MYSQL table?  The database is on google cloud

OR 1148 (42000): The used command is not allowed with this MySQL version

LOAD DATA LOCAL INFILE 'c:/Users/user/Desktop/products_export.csv' INTO TABLE Products
        COLUMNS TERMINATED BY ','
        LINES TERMINATED BY '\r\n';

Thanks

Rajiv

[Adam (Cloud Platform Support)]

This depends on where you're running that query. It will work if you're running this from the mysql client on your local machine, which will call mysqlimport with the '--local' option to read the local file. Anywhere else it will fail (not the least because there would be no way to access your C:/ drive).

This assumes your database is a Google Cloud SQL instance, is this correct?