Re: Downloading database tables
Irvin and Azadi Navicat was just what I was looking for. Thanks Rob On 18 Feb 2011 at 16:40, Irvin Gomez wrote: Navicat has scheduled, automated backups (any frequency). Works flawlessly. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Downloading database tables
Hi folks What is the best way of downloading web database to a local desktop machine. clients register for programs and the information is on the web database. I want to use coldfusion to update my local desktop database Thanks Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading database tables
This one comes up from time to time. The best way to do it is with you chosen database's own development and management tools. If you use MS SQL Server Management Studio, they have integrated tools to copy a database. If you use Toad, they have something too. I have always had... let's say limited luck with those, but if you can get by with that, you should Now, if you wanted to do this in CF, it probably means work. I actually have a semi-functioning model of downloading one database and applying it to another, even works across database engines (e.g. download from oracle and apply to derby). Plus it takes snapshots so you can save versions of the database, including basic schema snapshots that you can import into another database, too. Then I got distracted, lost interest and have a 75% finished program. I'd open source it, but like I said it's not fully functional (not even fully baked), and I don't know that there's a real market for it. Umm, I can probably hook you up with a copy, no promises that it will even compile. nathan strutz [http://www.dopefly.com/] [http://hi.im/nathanstrutz] On Fri, Feb 18, 2011 at 12:32 PM, Rob Voyle robvo...@voyle.com wrote: Hi folks What is the best way of downloading web database to a local desktop machine. clients register for programs and the information is on the web database. I want to use coldfusion to update my local desktop database Thanks Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading database tables
Hi Nathan I am using mySQL. On the VPS i have php based myadmin. Doesn't do a lot for me and then I tried to download that to my local machine. After dowloading and supposedly installing it I wasted a day scouring the web trying to configure it. I gave up in utter disgust at my inability to get it to run. Even cursed the existence of whoever wrote the %$#%^ thing. On my local machine I use mySQL workbench. While it was easy to install and runs well I have not found it intuitively easy to use (I am a real newbie to mySQL and databases in general) I actually find it easier to use the windows command line to create and alter tables. My basic tables are not going to be large I am just looking for a way in CF to export the data in the web table and include it into the local table. possibly exporting as a CSV file or creating a cfinclude on my local machine that access the web file. I don't think I need anything as extensive as your project, I just want to access the data in already formed tables. Yes it will take some time, but after the time I have wasted on propriety stuff like php I would rather create something that I know how it works and meets my needs. And once it is done can be applied to several other projects I have in the works. Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 On 18 Feb 2011 at 13:16, Nathan Strutz wrote: This one comes up from time to time. The best way to do it is with you chosen database's own development and management tools. If you use MS SQL Server Management Studio, they have integrated tools to copy a database. If you use Toad, they have something too. I have always had... let's say limited luck with those, but if you can get by with that, you should Now, if you wanted to do this in CF, it probably means work. I actually have a semi-functioning model of downloading one database and applying it to another, even works across database engines (e.g. download from oracle and apply to derby). Plus it takes snapshots so you can save versions of the database, including basic schema snapshots that you can import into another database, too. Then I got distracted, lost interest and have a 75% finished program. I'd open source it, but like I said it's not fully functional (not even fully baked), and I don't know that there's a real market for it. Umm, I can probably hook you up with a copy, no promises that it will even compile. nathan strutz [http://www.dopefly.com/] [http://hi.im/nathanstrutz] On Fri, Feb 18, 2011 at 12:32 PM, Rob Voyle robvo...@voyle.com wrote: Hi folks What is the best way of downloading web database to a local desktop machine. clients register for programs and the information is on the web database. I want to use coldfusion to update my local desktop database Thanks Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 2443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading database tables
Navicat has scheduled, automated backups (any frequency). Works flawlessly. Hi folks What is the best way of downloading web database to a local desktop machine. clients register for programs and the information is on the web database. I want to use coldfusion to update my local desktop database Thanks Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Downloading database tables
sqlyog or navicat are both great mysql management tools and have free editions. there is of course free mysql admin (part of mysql tools now, i think) downloadable from mysql website. since it is your vps, you can install one of these there as well, and configure remote access to your db, or just manually do a sql dump on the vps and download the .sql file it to your desktop and execute it to update your local db copy. beats phpmyadmin by a 1000 miles... in all cases make sure you back everything (database-wise) first before doing dumps/restoring. Azadi On 19/02/2011 04:58 , Rob Voyle wrote: Hi Nathan I am using mySQL. On the VPS i have php based myadmin. Doesn't do a lot for me and then I tried to download that to my local machine. After dowloading and supposedly installing it I wasted a day scouring the web trying to configure it. I gave up in utter disgust at my inability to get it to run. Even cursed the existence of whoever wrote the %$#%^ thing. On my local machine I use mySQL workbench. While it was easy to install and runs well I have not found it intuitively easy to use (I am a real newbie to mySQL and databases in general) I actually find it easier to use the windows command line to create and alter tables. My basic tables are not going to be large I am just looking for a way in CF to export the data in the web table and include it into the local table. possibly exporting as a CSV file or creating a cfinclude on my local machine that access the web file. I don't think I need anything as extensive as your project, I just want to access the data in already formed tables. Yes it will take some time, but after the time I have wasted on propriety stuff like php I would rather create something that I know how it works and meets my needs. And once it is done can be applied to several other projects I have in the works. Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 On 18 Feb 2011 at 13:16, Nathan Strutz wrote: This one comes up from time to time. The best way to do it is with you chosen database's own development and management tools. If you use MS SQL Server Management Studio, they have integrated tools to copy a database. If you use Toad, they have something too. I have always had... let's say limited luck with those, but if you can get by with that, you should Now, if you wanted to do this in CF, it probably means work. I actually have a semi-functioning model of downloading one database and applying it to another, even works across database engines (e.g. download from oracle and apply to derby). Plus it takes snapshots so you can save versions of the database, including basic schema snapshots that you can import into another database, too. Then I got distracted, lost interest and have a 75% finished program. I'd open source it, but like I said it's not fully functional (not even fully baked), and I don't know that there's a real market for it. Umm, I can probably hook you up with a copy, no promises that it will even compile. nathan strutz [http://www.dopefly.com/] [http://hi.im/nathanstrutz] On Fri, Feb 18, 2011 at 12:32 PM, Rob Voylerobvo...@voyle.com wrote: Hi folks What is the best way of downloading web database to a local desktop machine. clients register for programs and the information is on the web database. I want to use coldfusion to update my local desktop database Thanks Rob ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 2443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm