I've done plenty with phpmyadmin, but it certainly is not great. Good for quick edits and mysqldump for backup :)
But what about scheduling jobs? Yeah, script it in the shell and put in crontab. Replication. Yeah, write a script or two for dumping and restoring selectively. Scheduling replication is then solved as well since we've got both sets of tools.... But all that's a lot of work. I'm not knocking MySQL -- like I've said, I use it frequently and I really dig where the new control center is headed as a management tool. But it's missing stuff and some of it is a deal killer when you need to implement real solutions today. Now 2 years from now, maybe we're in a different situation :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Roberson, Jeff, Mr (Contractor) ACI" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 15, 2003 10:48 AM Subject: RE: WOT: MySQL in the Enterprise > I use phpmyadmin even though it doesn't have everything it's pretty good. > > And better than straight command line. > > -----Original Message----- > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 10:20 AM > To: CF-Talk > Subject: Re: WOT: MySQL in the Enterprise > > > > samcfug wrote: > > > The soon to be 4eleased version 4 of MySQl, will definitely bring it > into the > > > mainstream and direct competition with Oracle and SQL2k > > > (stored procedures and triggers) > > > > Although version 4.0 will be out Real Soon Now(tm), it will be a far cry > > from a real cross the board competitor. unicode (rather important with > > CF MX and i18n) and subqueries are only due in 4.1, and triggers and > > stored procedures 'have to be done sometime' (which means version 5 at > > best). Views is even later as triggers and stored procedures. > > > > They are making progress, but they have an awfull long road ahead. > > > > Jochem > > Not to mention the fact that *management tools* are a key feature of > databases. Spend a lot of time using osql in MSSQL? How often do you > schedule jobs using the sp_addjob (know how to figure out the int for > @frequency?). I'm all for the command line, but just getting a taste of the > MySQL Control Center made me realize how much a front-end tool contributes > to usability. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
