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