MYSQL_ScriptExec

Utility to execute MySQL scripts or multiple scripts from text file.

ScreenShot

Initially, a connection must be established to and database. You can optionally specify a database that does not exist, and by checking the ‘created if does not exist’ checkbox, the system will created and empty database. Otherwise, a non-existent database will result in an error message.

ScreenShot

If desired, MySQL_ScriptExec runs can be logged to a table for review in the LogMaintenance page:

ScreenShot

Options are set on the options page:

ScreemShot

This utility is based on a SQL Server utility created by Roman Rehak

Example folder contains sample text files and scripts to demonstrate how to format them for execution. The samples use the MySQL ‘world’ schema.