Error Code: 1148. The used command is not allowed with this MariaDB version June 27, 2020 admin MYSQL 0 Comments “ERROR 1148. The used command is not allowed with this MySQL/MariaDB version” when doing LOAD DATA LOCAL FILE with MySQL Workbench. Solution: In the advanced tab of the connection, put OPT_LOCAL_INFILE=1 in the others box. LOAD DATA LOCAL FILEmariadbmysql Share This Tweet Share Share Email Related Posts How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu LOAD DATA LOCAL INFILE – Example How to import data from csv, txt or other export files into MYSQL Syntax: LOAD… Mysql Innodb: InnoDB: ERROR: the age of the last checkpoint is InnoDB: which exceeds the log group capacity STEP 01) Change the following in /etc/my.cnf [mysqld] innodb_log_buffer_size = 32M innodb_buffer_pool_size = 2G innodb_log_file_size… This Post Has 0 Comments Leave a Reply Cancel replyYou must be logged in to post a comment.