mySQL DBA Software

Question

Are the free mySQL GUI tools adequate for administering a mySQL db running 'vendor' supplied applications?

Are there other tools you would recommend that make your life easier?

Answer 1

There's:

• phpmyadmin - been around for ages & packed with features
  
• SQLYog - which used to be open source, but now offers a 'community edition'

There's also MySQL Administrator which is provided by mysql although I've never used it.

Other tools: For backup:

• zmanda offer a community version backup tool
• xtrabackup as mentioned by pQd is fantasic & open source

Answer 2

i'm surprised maatkit was not mentioned yet. it does not provide any fancy gui applications, instead it gives dba set of command line tools that can be used to analyze mysql logs, diff and synchronize content of databases, run faster database dumps [ by executing parallel queries ]. you can read more here.

another useful tool - xtrabackup - free & open source hot backup of innodb databases.

Answer 3

Navicat for MySQL (there are also Oracle and PostgreSQL versions too). Not free though. US$179 for the downloadable version ($189 for the CD). Highly recommended for all MySQL DBAs and developers using MySQL.

There is a trial version available as well.

Answer 4

Propably look into:

HeidiSQL - made my life easier

and

MySQL Workbench

Answer 5

PHPMyAdmin is a great tool.

Answer 6

You can also use : Database Workbench or SQL Manager or MySQL Maestro