Date: Wed, 03 Jan 2001 21:44:50 -0500 From: mikel <mikel@ocsinternet.com> To: freebsd-questions@FreeBSD.ORG Subject: Re: a very dumb backup question Message-ID: <3A53E3A2.157AD284@ocsinternet.com> References: <DBEIKNMKGOBGNDHAAKGNCEENCLAA.dave@hawk-systems.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is the same method we use only diff is if the bottom drops out we just reinstall the db from the ports and use the dumps to recreate everything...I usually take the opportunity to upgrade as well... On a side note we use ( http://www.ocsny.com/main/index.ocs?url=mysqlbackup ) to perform the mysqldumps, as it has auto database discovery, thus we never have to edit the scripts as databases are created or dropped...working on a postgres version... Cheers, mikel Dave VanAuken wrote: > do a dump of the databases to get around this... for example, we cron > mysqldump and pgsqldump each morning at 3am... once complete you have > an accurate 3am "snapshot" of the database, then run your backup > immediately thereafter (we have it all in the same shell script). > > on disaster, rebuild the server from the backup and then delete the > database data (which may be erronious if backed up mid session or > something) and restore from the database dumps. > > We also have some e-commerce/critical db files that get incrementially > dumped and rotated thruout the day to cover disasters between nightly > backups. the brief overhead of a pg_dump for 30-60 seconds every hour > is a small price to pay for recovering a few thousand dollars in > transactions that would otherwise dissapear into never never land. > > html file changes are less of a worry since any changes uploaded to > the server should be available fo reload from your development station > in the event of a disaster. > > Dave > > -----Original Message----- > From: owner-freebsd-questions@FreeBSD.ORG > [mailto:owner-freebsd-questions@FreeBSD.ORG]On Behalf Of Christoph > Sold > Sent: Wednesday, January 03, 2001 6:39 PM > To: Eric_Stanfield@kenokozie.com > Cc: freebsd-questions@FreeBSD.ORG > Subject: Re: a very dumb backup question > > Eric_Stanfield@kenokozie.com schrieb: > > > > I have a number of freebsd boxes up that I've been backing up over > the wire > > using samba shares and nt backup software. In my ignorance as a > newbie I > > didn't know if sticking a tape drive in the servers and using tar to > > perform backups would catch open files. In my somewhat lesser > ignorant > > state as a familiar freebsd guy, I still don't know so I figured I'd > ask. > > Will open files (web pages, etc) be backed up to tape using tar? > > Yes. The problem is, you may capture them while in an inconsistent > state. For this reason, databases should be powered down when backup > time hits the disc. > > HTH > -CHristoph Sold > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3A53E3A2.157AD284>