Darioush

OK, what do you use to administrator your local MySQL database? I've used the command-line (yeah, hardcore), the dbEdit plugin for Eclipse (limited and quirky) and CocoaMySQL (freeware but also limited and quirky). I also tried MySQL's official client but that's really flaky. I've heard good things about Navicat and I'm trying that now. It's great but... well... it's a hundred bucks! Sheesh. Is it really worth it?

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com

Darioush

I found the pre-7.0 versions of Navicat (on Windows) to be the most bug-ridden commercial software I've ever used. I'm not going to list all my complaints here, but suffice it to say that it was like a bad alpha build until v7.0 was released. What's more, after being initially helpful, or at least honest and admitting to bugs and glitches, Navicat support didn't respond to two of my support requests (about further buggy behaviour), something which left a further bad taste. Having said all this, post 7.0 versions are much improved it seems (again, on Windows). Yes, I stuck with it because the 'competition' seemed little better. Now that it has settled down I find it to be a very useful application -- for me, worth the money. It certainly slaps a more relaxed face on MySQL and has some genuinely useful functionality wrapped up in simple commands (such as the database backup and data transfer). Not sure to what extent the Win32 version is comparable to the Mac version in terms of reliability, but anyway, for what it's worth...

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com

Darioush

Yep, Navicat get's my vote, I use it for both OSX and on Windows. MySQL administrator is quite good too but doesn't have all the useful back kind of stuff that Navicat has. Also transferring data or synchronising data and / or structure of databases is possible and works pretty well. So yep, worth the money IMHO. For anyone that's come from using something like Access where you've got a visual interface to the database to using MySQL and all it's command line nature then Navicat does make it seem much friendlier.

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com

Darioush

I use SQLyog. As mentioned above there is a free version - short some "Powertools" which is more a matter of convenience. For a license fee of $9.00 for single user or for enterprise functionality at $47.00 - Well what can you say + you get the "Powertools"? I have used Navicat and PHPMyAdmin as well and don't find any major advantages over SQLyog. I really enjoy having the local copy to admin my local and remote dbs.

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com

Darioush

I may need to update ADS, but I absolutely hate it. I've actually taken to hand-scripting my MySQL DDL and using CFQUERY to execute it. For the money, it's the best thing out there. However that brings up a whole new question: Should we, as a community, create a CF-based SQL administrator like PHPMySQL that will work against MySQL, SQL Server, and Oracle? Hehehe... yeah, my eyes are rolling back in my head and I'm twitching too. It's a dream, probably a nightmare, but it may be just the thing we're wanting.
I have to say, though, that ADS (proviso: I may need to update the version I'm using), CocoaMySQL, and the MySQL administrator for OSX ALL SUCK PRETTY BADLY so if there's a commercial package out there that works at all it's got my vote before I've even used it. I'll check out Navicat tonight, hopefully, and see how it fares.
Laterz!

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com

Darioush

Sean, I use "SQL Manager 2005" from www.mysqlmanager.com. The last time I checked it was only available for Winblows but they may have a version for you special people. :-)
I used to use Aqua Data Studio as previous peeps already mentioned, however, I was not too impressed with it. To be fair though, it has been awhile since I checked it out so it may have improved.
Shimju David,
phpmyadmin.net?? Seriously? It sucks!.. royally!
-Tango

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com

Darioush

I use Aqua Data Studio from Aqua Fold [www.aquafold.com]. Its commercial software but they have non-commercial and eduational licenses available. The great thing about it is that it can connect to pretty much any other DB server, SQL Server, Oracle, Sybase, PostgreSQL, etc. Its a one-stop shop!

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com

Darioush

If anyone was going to build another MySQL admin program using Coldfusion, it should done with a bunch of CFC's in a framework with a beautiful Flex front-end. Maybe an Apollo version for the desktop.

__________________
Napa Valley wine, wineries, on-line wine sales, lodging, vacations, golf, current events http://www.napavalley.com