Les Mikesell wrote at about 07:37:07 -0500 on Tuesday, August 25, 2009:
> Nigel Kendrick wrote:
> > Hi,
> >
> > This may also be applicable to MySQL etc..
> >
> > I have an MS-SQL database that dumps out a backup that's around 700MB in
> > size. BackupPC brought this over to its server via ADSL/VPN/Rsyncd
> > (422mins!) and when I did another data dump about 4 hours later, around
> > 16Mb of changes to the file were transferred very quickly. However,
> > every single backup since then has gone back to 422 minutes. I could
> > imagine that the database and dump will change over time, but it seems
> > strange that the entire file needs copying every time - as if its
> > structure is always 100% different from the previous.
> >
> > I wondered if I was missing anything obvious (being a BackupPC noob)
> > like file time stamping causing a complete file transfer every day, or
> > are database dumps likely to be completely different every time?
> >
> > I will keep some copies of the dumps and do some comparisons but in the
> > meantime any tips, thoughts etc.?
>
> I don't know anything about the contents of the file, but are these full or
> incremental runs for backuppc? Assuming this is rsync or rsyncd, note that
> incrementals always compare against the last full unless you have configured
> multiple incremental levels, so they tend to transfer more each time. Or
> there
> may just be enough difference that it can't find the matching parts.
>
> If you are running rsync with ssh (probably not if this is windows), you
> might
> save some time by adding the -C option for ssh compression. If transfer
> time is
> important, it might be worth setting up a scheduled rsync command to copy
> to
> something on the network local to the backuppc server so you could use the
> -z
> option (which backuppc doesn't support), then have backuppc pick up that
> copy to
> keep the history. Or, if rsync isn't finding matching parts anyway perhaps
> you
> could compress the file before the transfer.
Just out of curiosity, are there any plans to have rsync within
Backuppc recognize the -z (compression) flag?
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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/
|