As you might have read I really do like MySQL - the database engine, but I am having a really hard time with the admin tools.
As I am now into some heavy MySQL development again (comes and goes - 99 days of 100 it's MSSQL) I really felt I should take the time to investigate if there is something other useful out there.
While the MySqlFront project is dead ( I vaguely remember me using it maybe 5 years ago), my next stop was sqlyog.
And I never went any longer in my searches. So far is has been really nice! I needed a tool supporting the new MySQL 5.0 features such as stored procedures, views and functions - and look at it:
To edit an existing stored procedure, just rightclick and click Alter stored procedure:
In short it's very much like Enterprise Manager for MSSQL - when running a query (pressing F5) we are presented with results in the Results view:
Now some cool stuff - in the image above - see the button in the filedata column? It's a BLOB column and I have uploaded different types of data into it, sqlyog is able to find out what type of data it is - and the coolest of all. Click on the button:
We get to see the data! And even able to export it to a file. And when talking about export, while regular management routines (such as create database, backup, restore) are handled by the GUI - the export to textfile function is really nice and easy to use:
