- When exporting for MariaDB 10.4, make sure to turn GTID to off in the export advanced option tab. (command line: –setgtid-purged=OFF). The default is AUTO and importing the resulting export file will result in “unknown system variable”.
- If encounter error code 1175 while deleting rows from table, Workbench defaults to safe mode for deleting. Do the following to get around it:
- Go to edit->preference->SQL editor. Scroll down and uncheck the safe mode option.
- Right click on the database and choose refresh all
- If there was temporary tables, you need to recreate them.
- rerun the delete command
- reference: https://mkyong.com/mysql/cant-delete-records-in-mysql-workbench/