Re: REPOST: How do _you_ back up your db?

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29706
interpreted = N
texte = I do pretty much the same thing but I use [shell] to tar+compress+move the files.You don't get much feedback probably because almost everybody uses the same or a similar method.The others just realized that they probably should. :)Clem.Joseph D'Andrea wrote: > > REPOSTING because either a) no one wants to talk to me or b) no one > actually backs up their databases. > > How do _you_ back up your db? > > Here's how I do it... > > I have a template that is admin protected that I hit with a trigger > every 12 hours. Here's what it does... > > [text]t_NewFileDate=[date %Y%m%d]-[time %H%M%S][/text] > > [commitdatabase db=some.db] > [COPYFILE from=some.db&to=^/WC.backup/[t_NewFileDate]-some.db] > > I do a commitdatabase so that I make certain that I get an up to date > copy of the database prior to doing the copy. > > Then sometime later, I will use either TB2 or Retrospect to copy the > WC.backup folder to an off-site volume. > > I had originally tried to use Retrospect, TB2 or the Finder with > AppleShare to copy the files directly but they are in constant use > with records being appended and those methods often failed as the > database changed or grew during the copy. > > Anyone have a better technique? > > ___Joe___ >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: REPOST: How do _you_ back up your db? (Michael O Shea 2000)
  2. Re: REPOST: How do _you_ back up your db? (Nico 2000)
  3. Re: REPOST: How do _you_ back up your db? (Michael O Shea 2000)
  4. Re: REPOST: How do _you_ back up your db? (Nicolas Verhaeghe 2000)
  5. Re: REPOST: How do _you_ back up your db? (Stephen Reiss 2000)
  6. Re: REPOST: How do _you_ back up your db? (Robie Blair 2000)
  7. Re: REPOST: How do _you_ back up your db? (Paul Fowler 2000)
  8. Re: REPOST: How do _you_ back up your db? (James Howarth 2000)
  9. Re: REPOST: How do _you_ back up your db? (Robie Blair 2000)
  10. Re: REPOST: How do _you_ back up your db? (Clement Ross 2000)
  11. Re: REPOST: How do _you_ back up your db? (Kenneth Grome 2000)
  12. Re: REPOST: How do _you_ back up your db? (jpeacock@univpress.com 2000)
  13. REPOST: How do _you_ back up your db? (Joseph D'Andrea 2000)
I do pretty much the same thing but I use [shell] to tar+compress+move the files.You don't get much feedback probably because almost everybody uses the same or a similar method.The others just realized that they probably should. :)Clem.Joseph D'Andrea wrote: > > REPOSTING because either a) no one wants to talk to me or b) no one > actually backs up their databases. > > How do _you_ back up your db? > > Here's how I do it... > > I have a template that is admin protected that I hit with a trigger > every 12 hours. Here's what it does... > > [text]t_NewFileDate=[date %Y%m%d]-[time %H%M%S][/text] > > [commitdatabase db=some.db] > [COPYFILE from=some.db&to=^/WC.backup/[t_NewFileDate]-some.db] > > I do a commitdatabase so that I make certain that I get an up to date > copy of the database prior to doing the copy. > > Then sometime later, I will use either TB2 or Retrospect to copy the > WC.backup folder to an off-site volume. > > I had originally tried to use Retrospect, TB2 or the Finder with > AppleShare to copy the files directly but they are in constant use > with records being appended and those methods often failed as the > database changed or grew during the copy. > > Anyone have a better technique? > > ___Joe___ >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Clement Ross

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

RE: Languages (1997) The Best Shopping Cart Solution I Have Come Upon (2003) Showing unopened cart (1997) Outlook Rule (2002) autosensing lanague selection (1997) [WebDNA] Better names ... (2012) Re[2]: Base64 encryption limitations? (1999) WebCat2b12plugin - [search] is broken ... not! (1997) 2.0.1 new commands and contexts (1997) Credit Card Number checking (1997) WebCat2 - [format thousands] (1997) Items in cart (2000) SKU's (2000) WebCatalog Affiliates Program ... (2000) Need help with Shipping/Price discounts (1998) Multiple catalog databases and showcart (1997) Version 2.1.3 changes ... (1998) [OT] MACWORLD (2003) [TaxableTotal] - not working with AOL and IE (1997) [WebDNA] v.7 and eCommerce (2012)