Re: REPOST: How do _you_ back up your db?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29734
interpreted = N
texte = Hey, good Idea! And while we are at it, we better have a backup server for the backup to be back'd up to, then backup the backup with a redundant backup. . .wait, was that too many backups? ;-)Rob> From: James Howarth
> Reply-To: (WebCatalog Talk) > Date: Tue, 28 Mar 2000 21:29:41 -0800 > To: (WebCatalog Talk) > Subject: Re: REPOST: How do _you_ back up your db? > > Well heck, you better back up the whole server! Unless you want to be > broke. > > James Howarth ********************************** > Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) > 16855 West Bernardo Drive | Software & Site Development > Suite 380 | > San Diego, CA 92127 | > 858.675.1106 | http://www.smithmicro.com/isd > 858.675.0372 (fax) > > -----Original Message----- > From: Robie Blair [mailto:rblair@anythingpc.com] > Sent: Tuesday, March 28, 2000 9:27 PM > To: WebDNA-Talk@talk.smithmicro.com > Subject: Re: REPOST: How do _you_ back up your db? > > > Why stop at just backing up the databases? Seems to me that the > databases > are worthless without the code to utilize them. . . > Go fer broke. . .if you are gonna spend the time, backup the whole > folder. . > .Zip it up, and rename it the date of backup. . .works for me. . . > > > Rob > ......................................................... > Rob Blair > Manager of Web Technology > Anything Internet Corporation > 3020 North El Paso, Suite 103 719.227.1903 x105 > Colorado Springs, CO 80907-5454 FAX 719.227.1907 > rblair@anythinginc.net > http://www.anythinginc.net > ......................................................... > >> From: Clement Ross >> Reply-To: (WebCatalog Talk) >> Date: Tue, 28 Mar 2000 19:39:44 >> To: (WebCatalog Talk) >> Subject: Re: REPOST: How do _you_ back up your db? >> >> 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 >> > > > ------------------------------------------------------------- > 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 > > > ------------------------------------------------------------- > 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 > ------------------------------------------------------------- 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:
Hey, good Idea! And while we are at it, we better have a backup server for the backup to be back'd up to, then backup the backup with a redundant backup. . .wait, was that too many backups? ;-)Rob> From: James Howarth > Reply-To: (WebCatalog Talk) > Date: Tue, 28 Mar 2000 21:29:41 -0800 > To: (WebCatalog Talk) > Subject: Re: REPOST: How do _you_ back up your db? > > Well heck, you better back up the whole server! Unless you want to be > broke. > > James Howarth ********************************** > Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) > 16855 West Bernardo Drive | Software & Site Development > Suite 380 | > San Diego, CA 92127 | > 858.675.1106 | http://www.smithmicro.com/isd > 858.675.0372 (fax) > > -----Original Message----- > From: Robie Blair [mailto:rblair@anythingpc.com] > Sent: Tuesday, March 28, 2000 9:27 PM > To: WebDNA-Talk@talk.smithmicro.com > Subject: Re: REPOST: How do _you_ back up your db? > > > Why stop at just backing up the databases? Seems to me that the > databases > are worthless without the code to utilize them. . . > Go fer broke. . .if you are gonna spend the time, backup the whole > folder. . > .Zip it up, and rename it the date of backup. . .works for me. . . > > > Rob > ......................................................... > Rob Blair > Manager of Web Technology > Anything Internet Corporation > 3020 North El Paso, Suite 103 719.227.1903 x105 > Colorado Springs, CO 80907-5454 FAX 719.227.1907 > rblair@anythinginc.net > http://www.anythinginc.net > ......................................................... > >> From: Clement Ross >> Reply-To: (WebCatalog Talk) >> Date: Tue, 28 Mar 2000 19:39:44 >> To: (WebCatalog Talk) >> Subject: Re: REPOST: How do _you_ back up your db? >> >> 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 >> > > > ------------------------------------------------------------- > 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 > > > ------------------------------------------------------------- > 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 > ------------------------------------------------------------- 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
Robie Blair
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:
shipping costs (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
WebCat2 - [format thousands] (1997)
Great product and great job ! (1997)
[searchString] (1997)
Country & Ship-to address & other fields ? (1997)
[WebDNA] WebDNA 6.1 Info (2008)
Thanks for tips, more quest (1997)
Calculating multiple shipping... (1997)
Protecting webdelivery (1997)
problems with 2 tags (1997)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
Virtual hosting and webcatNT (1997)
[WebDNA] TCPConnect w/ user:pass (2009)
Securing/hiding database file (2000)
MacAuthorize order data fields WAS:How To question... (1997)
Odd