-----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 [email protected] List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
