MySQL management tool MySQL utilities-introduction and installation (1)

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 connector/python:http://dev.mysql.com/downloads/connector/python/

MySQL Utilities Source Installation

12345

# 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"

1	# yum Install Mysql-utilities.noarch

Ubuntu/debian

How to be a Debian system will download the corresponding Debian package. You can also configure the source.

12	# 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

Windows

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)