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 thefiles.You don't get much feedback probably because almost everybody uses the sameor 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:
I do pretty much the same thing but I use [shell] to tar+compress+move thefiles.You don't get much feedback probably because almost everybody uses the sameor 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)