ERROR 1148: The used command is not allowed with this MySQL version

<<Back to MySQL & MariaDB How To Page

ERROR 1148: The used command is not allowed with this MySQL version

$sudo mysqlimport --fields-terminated-by=, --fields-enclosed-by=\" --columns NAME,DEPT test /tmp/import_mysqlload.csv
ERROR 1148: The used command is not allowed with this MySQL version

Solution:

Set the local_infile parameter and re-run the import.

MariaDB [(none)]> SET GLOBAL local_infile = 1;

MariaDB [(none)]> show global variables  like '%infile%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | ON    |
+---------------+-------+
1 row in set (0.00 sec)