BackupPC-users

Re: [BackupPC-users] how does backuppc handle DBs

2009-02-07 11:06:35
Subject: Re: [BackupPC-users] how does backuppc handle DBs
From: John Rouillard <rouilj-backuppc AT renesys DOT com>
To: "General list for user discussion, questions and support" <backuppc-users AT lists.sourceforge DOT net>
Date: Sat, 7 Feb 2009 16:04:15 +0000
On Sat, Feb 07, 2009 at 08:55:27AM -0500, Nick Smith wrote:
> ok, i use volume shadow so i dont need to dump.

Umm, I assume you are telling the database that you are going to
snapshot it's database so it syncs all of the data to disk to make it
consistant when you snaphot the volume right?

If the database support PITR, you must be doing the standard backup a
corrupted database and the rollback/journal logs that are needed to
recover the corrupted database.

If you aren't doing one of these two things (manually or
automatically) and have restorable backups, you are just lucky.

> what does it do for the backup after you have dumped the DB?
> does it only take what has changed since the
> last dump or does it take the entire dump?

If the file is changed, it backs up the entire file, but using rsync
it only transfers deltas between the prior verion of the file and the
current version. If using tar/smb it copies the entire fileover the
wire.

Also it can compress the file on disk. Do you see files under
/backuppc-root/cpool? Does the compressed size of the source file
approximate the size of the file you find on disk?

-- 
                                -- rouilj

John Rouillard
System Administrator
Renesys Corporation
603-244-9084 (cell)
603-643-9300 x 111

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/