1.4 MySQL Utilities

MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. These utilities encapsulate a set of primitive commands, and bundles them so they can be used to perform macro operations with a single command. They can be installed via MySQL Workbench, or as a standalone package.

They are a set of command-line utilities and a Python library for making the common tasks easy to accomplish. The library is written entirely in Python, meaning that it is not necessary to have any other tools or libraries installed to make it work. It is currently designed to work with Python v2.6 or later and there is no support (yet) for Python v3.1.

The utilities are available under the GPLv2 license, and are extendable using the supplied library.

For more information, see the MySQL Utilities manual at http://dev.mysql.com/doc/index-utils-fabric.html.

Installing The MySQL Utilities

MySQL Utilities development is managed elsewhere, and require a separate download. Attempting to start the MySQL Utilities when they are not installed will prompt for a download and their installation. See the MySQL Utilities manual for additional information.

Note

MySQL Workbench searches for the mysqluc MySQL Utility in the system's PATH to determine if the MySQL Utilities are installed.

Opening MySQL Utilities From MySQL Workbench

Open the MySQL Utility mysqluc (MySQL Utilities Unified Console) from MySQL Workbench from either the Tools menu, or from the MySQL Utilities shortcut on the Home page.

Figure 1.41 Open MySQL Utilities From Workbench

Open MySQL Utilities From Workbench

The MySQL Utilities console window can be seen below, with the "help" command executed:

Figure 1.42 The MySQL Utilities Console

The MySQL Utilities Console