Well please correct me if my thinking is not correct.
im using volume shadow, which is suppose to be a way to backup in use
files without unmounting or corrupting them.
the volume shadow and backups are being done after hours at a time
when no one is logged on and making any changes to the database.
so from what ive read and understand this is a safe way to backup sql
and exchange.
i could edit the pre/post scripts that launches the volume shadow to
unmount the sql and exchange dbs of you guys think that would be
a safer way. it just adds a bit of complexity to a relatively easy
script. and i am no programmer, i thought i was lucky to get this far.
I do understand the fact that an untested backup is no backup at all,
i just need to figure out a good time to bring a doctors office down
thats two hours away to do the testing.
I am doing ony full backups with rsyncd over a site to site vpn
connection. i think what you are saying is that rsync will do a
compare on the
original file and only transfer whats changed correct? someone else
on here told me that repeated full backups do pretty much the same as
an incremental with a little more cpu overhead and slightly increased
disk usage, does that still stand as correct?
if it is actually only transmitting the changes in the db file, then i
could see how the backup was only taking 40mins. i just dont
understand
why it tells me im backing up 10gigs. unless its just telling me the
size of the file is 10gigs and its telling me its backed up.
thanks for the posts any other input would be much appreciated.
On Sat, Feb 7, 2009 at 10:53 AM, David Morton <mortonda AT dgrmm DOT net> wrote:
> -----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/
>
------------------------------------------------------------------------------
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/
|
