MySQL Utilities Introduction
MySQL Utilities provides a set of command-line tools for maintaining and managing MySQL servers, including:
- Administrative Tools (clone, copy, compare, diff, Export, import)
- Replication tools (Installation, configuration)
- General tools (disk usage, redundant indexing, search metadata)
MySQL Utilities is a series of command-line tools and the Python library is easier to manage tasks. Libraries are written in the Python language, which means you don't need to install any other tools and libraries. It is currently designed based on the Python2.6 version and does not support the Python3.1 version.
MySQL Utilities provides a variety of platform packages, if not found corresponding to their platform package, can be compiled through the source code installation.
The latest MySQL utilities can be downloaded here: http://dev.mysql.com/downloads/utilities/
MySQL Utilities Dependent Environment
MySQL Utilities requires a Python2.6 version, and all of the code is written based on that version. At the same time, the connection is required to drive the MySQL connector/python generic version (higher than 1.0.8).
MySQL Utilities Source Installation
||# wget-c Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-utilities-1.5.3.zip # unzip Mysql-utilities-1.5.3.zip # CD mysql-utilities-1.5.3 # python./setup.py build # python./setup.py Install
You may be asked to install the driver first Connector/python
Yum Source Installation
The MySQL yum source can be configured and can be installed directly from Yum. MySQL Yum source usage can be found in: "How to use MySQL Yum source to install update MySQL related software package"
||# yum Install Mysql-utilities.noarch
How to be a Debian system will download the corresponding Debian package. You can also configure the source.
||# wget-c Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-utilities_1.5.3-1debian6.0_all.deb # dpkg-i Mysql-utilities-1.5.3-debian6.0_all.deb
x86 32-bit: Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-utilities-1.5.3-win32.msi
x86 64-bit: Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-utilities-1.5.3-winx64.msi
The next step is nothing to say.
Mac OS X
Mac OS X 10.6:HTTP://DEV.MYSQL.COM/GET/DOWNLOADS/MYSQLGUITOOLS/MYSQL-UTILITIES-1.5.3-OSX10.6.DMG
Mac OS X 10.7:HTTP://DEV.MYSQL.COM/GET/DOWNLOADS/MYSQLGUITOOLS/MYSQL-UTILITIES-1.5.3-OSX10.7.DMG
Mac OS X 10.8:HTTP://DEV.MYSQL.COM/GET/DOWNLOADS/MYSQLGUITOOLS/MYSQL-UTILITIES-1.5.3-OSX10.8.DMG
Mac OS X 10.9:HTTP://DEV.MYSQL.COM/GET/DOWNLOADS/MYSQLGUITOOLS/MYSQL-UTILITIES-1.5.3-OSX10.9.DMG
First here, the next section describes how to connect to a MySQL server.
MySQL management tool MySQL utilities-introduction and installation (1)