How to run a sql file in MySql Workbench without to load it?

Question

I have a large sql file to run inside workbench. It has 44MB. So when I try to open it using "Open SQL Script" it freezes workbench.

I could do that through command line, but I would like to know if it's possible to run the query directly without loading in workbench.

That means, I would have only the query results in output.

Answer 1

MySQL Workbench has been tested with files up to 256MB. It takes a while to entirely syntax check such a file but it works. If you just want to run the file with ease use the File -> Run Script menu entry.