Appendix F 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 with 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.

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 PATH to determine if the
MySQL Utilities are installed.

Opening MySQL Utilities From MySQL Workbench

To open the MySQL Utility mysqluc (MySQL Utilities
Unified Console) from MySQL Workbench, select Start Shell
for MySQL Utilities from the Tools
menu. The following figure shows the MySQL Utilities console window
with the help command executed.