MySQL Design and Administration Tools – Q3 2011

This is a quick update to a previous post MySQL Design and Administration Tools – Q1 2011 where I looked at the different tools available for MySQL design and administration.

This post is an interesting one and adds updates for a few of the tools:

a) PhpMyAdmin (www.phpmyadmin.net)  – the web based power tool got a recent Web 2.0 upgrade so it really looks nice

b) Adminer (www.adminer.org) – has now become an essential tool in my work chest since its a single file deployment. Saves the hassles of having to log into control panels to access PhpMyAdmin

c) Quest Toad for MySQL (http://www.quest.com/toad-for-mysql/) – this is a new addition to the pack, a free tool in the Toad family which is well know in other database circles. While its style makes it more like SQL Yog, however its best feature is data comparison between two schemas. This has just proved to be a life saver on a project where we had to keep merging production data with out rapidly changing development schema.

Try these out and leave your comments to check out…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: