Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

closed as not constructive by voretaq7 Aug 25 '12 at 3:14

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

6 Answers 6

up vote 3 down vote accepted

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
share|improve this answer

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.

share|improve this answer
    
yes xtrabackup! I've heard its awesome, i couldnt remember the name –  Nick Kavadias Aug 22 '09 at 8:22

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.

share|improve this answer

Propably look into:

HeidiSQL - made my life easier

and

MySQL Workbench

share|improve this answer

PHPMyAdmin is a great tool.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.