How to fix en error when running an SQL Script in MySQL Workbench?

Question

I made an SQL Script (I checked it for errors and everything was fine). After that, I opened it in MySQL Workbench. I wanted to run it to view my query results. I clicked: File - Run SQL Script. I selected my file and it came up with an error:

error calling Python module function SQLIDEUtils.runSQLScript

What should I do to successfully run my script file?

Answer 1

In the MySQLWorkbench, instead of File > Run SQL Script, could you try to use File > Open SQL Script followed by Query > Execute (All or Selection)? This way, you should see an output from each query of the schema.sql script.

You could also try to use the mysql command (from a command line) instead. Or, splitting the schema.sql into smaller chunks to isolate the problem.

If nothing work I suggest you check the MySQL Workbench installation.