-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nick Smith wrote:
> ok, i use volume shadow so i dont need to dump.
> what does it do for the backup after you have dumped the DB?

That doesn't necessarily do the job - the database may be in the middle
of writing a change and the shadow copy could pick it up in an
inconsistent state.

To back up a database, you have to read the documentation for that
database. For example, a google search for "mysql backup" gets this for
a first hit:

http://dev.mysql.com/doc/refman/5.1/en/backup.html

YMMV for other databases.

At the very least, you may need to issue commands to flush tables and do
a read lock while you start the shadow snapshot, and then release the locks.

OTOH, doing a dump (such as mysqldump for mysql) usually means the dump
itself is in a consistent state, and backing up that file means you have
a consistent backup.  While your backuppc back may pick that up as well
as the binary database files, you don't know for sure if the dtatabase
files are consistent.

The other good thing about a dump is that it can be loaded on newer
versions of the database in case of a rebuild - I've heard horror
stories of when someone tried to restore a binary database file after a
crash, only to have it fail because the database versions didn't match.

Ultimately, the question you want answered is, "Can I restore the
database files and have them work".  Well, the answer to that is, of
course, "Test it!"  An untested backup is no backup at all.

As for the amount of data transfered, if you are doing a full backup, it
should transmit the entire file, but if you are using rsync and doing an
incremental, it should only transmit what has changed within a file.
tar and smb have to transmit a changed file in its entirety I belive.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkmNro0ACgkQUy30ODPkzl2mqwCdFodlm4g2rzuZ/SeXMqc667TE
9/sAoLKeH1A5YpKK0H+1cD8VvxJX523M
=M6sn
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
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/