Dwayne, The mySQL Administrator http://www.mysql.com/products/tools/administrator/ allows you to backup and restore your schemas to and from your remote server and local machine. And well, backup files generated from mySQL are .sql files that are pretty much self-contained... you just need to restore them.
The administrator is definitely much better that the clunky phpMySQL. For everyday maintenance, it works great... and I rarely have a need to use the mySQL command line. Best of all, its free. Use it with the mySQL Browser, and you'll get most of the db maintenance stuff accomplished. Michael > -----Original Message----- > From: Dwayne Cole [mailto:[EMAIL PROTECTED] > Sent: Friday, December 22, 2006 6:47 AM > To: CF-Talk > Subject: newbie: Tools to use with MySQL > > I feel like i did with eclipse 2 years ago. When I made the switch i was > like a baby in a candy store. > > I'm now ready to switch from Access to mySQL. Yeah, yeah what took me so > long? I had my reasons but now I'm ready and I was wondering if anyone > could provide me with some recommended administration tools. > > Current Development > Coldfusion 6.1 > CFEclipse > TopStyle > Windows 2000 > > New to my Arsonal > MySQL 5.0 > MySQL Tools. > > I co-locate and every time I need to work with a datasource I download the > MSAccess file to my local machine, make the changes then quickly upload > the updated version. It's akward. Particularly considering that I > manage as many as 25 live data sources (all with the same table > structure). From my understanding, this wont work with mySQL because > mySQL databases are not files. I wondering what's the process then. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
