1. I'm using the latest (1.1.8) version of MySQL administration and must say that's it's terrible to work with. While I earlier has had some problems with GUI freezing (need to kill process in Task Manager) especially when creating new databases, those errors are irritating but not things to kill for, if you understand what I mean
2. Now I found a really dangerous bug. I have been using MySQL Administration to create some stored procedures and first - I was testing a lot and copying SP:s between different databases - I was sure I had screwed it up myself. That was not the case. When clicking Create stored proc it replaces existing stored procedures instead of creating new ones. For example I have
a_ListActiveBanners
a_ListBannersForAdPosition
If I press button Create stored Proc and enter a_ListBannersForAdvertiser as the name it (when saved) replaces the a_ListBannersForAdPosition.
Not sure if they do some sort of matching and don't use all letters in the name.
The solution: Use Query browser instead. In the Schemata tree to the right you can right click on the database and Create new procedure/function.
Now lastly, to avoid flaming - please don't think I'm critisising MySQL as a database engine - I ensure you I love both the database engine and the company behind it. But I do think that the GUI tools has yet a long way to go.
Instead please let me know some alternatives - or simply your opinion in this forum thread
