Executing Large Scripts
Documenter for MySQL allows you to execute large scripts without opening them in the SQL editor and loading the whole script in memory. When you try to open a large script, you will be prompted to execute it with the help of Execute Script Wizard.
To execute a large script, do the following:
- To open Execute Script Wizard, on the Database menu, click Execute Large Script.
- In the Script location tab, click Connection and select one of the following options:
- choose an existing connection to a required database server against which you want to execute your script.
- click <Manage> and then in the Connection Manager dialog box, click New to set up a new coonection. For more information about how to set up a new database connection, see Connecting to a Database.
- In the Script location tab, from the Database drop-down list, select a database.
- In the SQL file name field, specify the path to the script you want to execute.
- In the SQL file encoding field, check that the file encoding is selected correctly. The program automatically selects it basing on the script. If it fails, the default encoding (the current Windows encoding on the machine where the program is running) is selected. You can always select a required encoding from the drop-down list.
- to execute the script, click Execute.
Tip: See all script execution messages in the Output window.