MySQL Administrator is a program for performing administrative operations, such as configuring your MySQL server, monitoring its status and performance, starting and stopping it, managing users and connections, performing backups, restoring backups and a number of other administrative tasks. You can perform most of those tasks using a command line interface such as that provided by mysqladmin (http://dev.mysql.com/doc/mysql/en/mysqladmin.html) or mysql (http://dev.mysql.com/doc/mysql/en/mysql.html), but MySQL Administrator is advantageous in the following respects:
* Its graphical user interface makes it more intuitive to use.
* It provides a better overview of the settings that are crucial for the performance, reliability, and security of your MySQL servers.
* It displays performance indicators graphically, thus making it easier to determine and tune server settings.
* It is available for Linux, Windows and MacOS X, and allows a remote client to backup the database across platforms. As long as you have access to the MySQL databases on the remote server, you can backup your data to wherever you have write access.
* There is no limit to the size of the database to be backed up as there is with phpMyAdmin.
MySQL Administrator is designed to work with MySQL servers versions 4.0 and above.
Getting MySQL Admin
MySQL Admin may be downloaded from the MySQL.Com site (http://dev.mysql.com/downloads/administrator/1.0.html). Installation binaries and documentation may also be found there.
Backing Up the Database
This assumes you have already installed MySQL Admin and set it up so that you can login to the MySQL Database Server either locally or remotely. Refer to the documentation that comes with the installation package of MySQL Admin for your platform for installation instructions.
1. Open the MySQL Admin client and login as you had previously set up to do.