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/