The new [URL=http://www.sitepoint.com/blog-post-view.php?id=151673]MySQL Administrator[/URL] is looking to be more robust and very enterprise friendly with its tools for managing multiple database servers, replication and disaster recovery tools. Getting this installed is pretty straightforward, however, remember, as MySQL is reminding everyone, that this is an alpha release and hence not intended for production environments. Please backup your data prior to installing on your machine.
Getting the binary download installed for Linux is very simple. Get the file from MySQL at this url –>
http://www.mysql.com/downloads/administrator.html and issue the following commands (recommendations from MySQL):
gzip -dc mysql-administrator-1.0.1a-alpha-linux.tar.gz | tar xv -C /opt
MySQL Administrator’s binary will be installed in /opt/mysql-administrator/bin,
from where you can execute ‘mysql-administrator’ to start the application.
The GUI is also available for Windows if you are administering your MySQL database servers from the Microsoft platform, and can be found on the same link above.
Finally, to build from source please follow these instructions from the MySQL FAQ included with the MySQL Administrator.
From MySQL Administrator FAQ.txt
Q: Which versions of Linux are supported by MySQL Administrator?
A: MySQL Administrator has been tested on:
- Debian unstable
- Fedora core 1
- SuSE 9
Most libraries, including Gtk+ are statically linked, except for the
following standard libraries:
Q: What do I need to build MySQL Administrator?
A: Apart from the g++ development suite, you will need the following
libraries and corresponding development packages:
Q: How can I build MySQL Administrator myself?
A: The following BitKeeper modules can be downloaded from
http://mysql.bkbits.net, using the BitKeeper version management system:
For each directory, execute the following commands:
If everything went well, you should have the mysql-administrator binary
built and installed in /usr/local/bin.