|Previous Index Next How To Use|
Besides the Script Editor, there's also the Script Runner tool.
You can use the Script Runner to execute a (very) large script without loading it into the Script Editor. When a script is very large, the Script Editor, with its syntax highlighting and line display, can get very slow.
To avoid this, use the Script Runner, which loads the script from file while executing and only displays a single statement at the time (large statements, like the multi-INSERT statements in MySQL are truncated for display purposes).
Script Runner, running a script on a MySQL database
As you can see in the above screen shot, you select a script file, an optional result file, in which all executed statements and errors end up, and the option to explicitly issue a database COMMIT after all statements have executed. This can be helpful if the script forgets a last COMMIT statement.