Re: REPOST: How do _you_ back up your db?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29724
interpreted = N
texte = 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
Associated Messages, from the most recent to the oldest:
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
James Howarth
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:
[OT] Server check please (2006)
WebCat Hosting - Pricing Question (2002)
Search in 2 or more catalogs (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
Not really WebCat (1997)
Question about links (1999)
The IBC root beer has arrived! (1997)
Add more fields to an existent data base (1997)
How to include weather (2000)
Grep Question - MAY NEVER BE SOLVED (2003)
Giving out error pages (1997)
WebCat 4 crashes WebStar / Shownext Links (2001)
Re:quit command on NT (1997)
Accepting credit cards (1997)
still facing truncated [texta] problem (2000)
customizing the color of user's pages (1997)
search form problem.. (1997)
Updating product information (2002)
[ShowNext] (1997)
formula??? (2000)