Search code examples
mysqlload-data-infile

How to solve Error 1148 from MySql workbench and not cmd?

I am running the following statement to import data:

LOAD DATA LOCAL INFILE     'C:\\Users\\talkohavy\\Desktop\\MySQL_data\\categories.csv'
INTO TABLE BI_EX_OLTP.categories 
FIELDS TERMINATED BY ','
IGNORE 1 LINES;

And then I get this error:

error code 1148. the used command is not allowed with this mysql version.

How can I enable loading local data using the MySql Workbench and not the cmd?

Solution

  • I believe this is an issue with the new versions of Workbench (having the same issue in Workbench 8.0.12). I did not have this issue in the 5.7.x version of Workbench, and downgrading to this version has fixed the issue for me.

    This bug is documented here: https://bugs.mysql.com/bug.php?id=91891

    I recommend either downgrading to an older version of Workbench, or using a different means to execute the command (such as through the mysql CLI command, or using another tool to connect such as DataGrip, etc).