Let us get this straight. You are making local flat-file backups of your database, and then the flat file backups are getting backed up by BackupPC? This is the way that it should be done. There's no point backing up the actual database files unless the database is broucht offline in a way that's coordinated with the backup. Any update to the database during the backup could corrupt the results and make a successful restore impossible.
So say you have three flat files: db.backup.2007-12-01.sql db.backup.2007-12-08.sql db.backup.2007-12-15.sql There will only ever be one copy of each file in the BackupPC pool. You could run three fulls and ten incrementals. BackupPC is smart enough to realize that they are the same file coming back to it. It will create an empty link for that particular backup and it's done. Sorry just my 2 cents.. Maybe we're beyond this but I wasn't sure if it was clear... "Rob Ogle" <[EMAIL PROTECTED]> wrote: > Ok...so...since the beef of my backup is a sql database backup file that is > 3.5GB. The reason I've got so much data is because the I have about 8 copies > of it. One for the full and one of the incremental of each day between > fulls. Right? > > If so...how do I tweak my settings so that I only have one copy of it? Set > incremental to -1 and full to 1? > > > -----Original Message----- > From: John Pettitt [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 13, 2007 5:17 PM > To: [EMAIL PROTECTED] > Cc: 'Les Mikesell'; [email protected] > Subject: Re: [BackupPC-users] Deleted Host > > Rob Ogle wrote: >> Thanks! >> >> I changed those settings, restarted the box, and ran BackupPC_nightly. >> My directory size hasn't changed. Should I just wait a few days to see if >> the magic happens on it's own? >> >> >> >> > Unless your machine changes *a lot* each week the directory size won't > change much. This is becasue backuppc pools the files. When a new > full backup happes if the file already exists it just gets linked taking > no additional disk space - this is why the directory doesn't grow by a > huge amout with each full. The flip side of this is when a full gets > deleted only the files that were unique to that full actually get > removed from the disk - if the same file is used in another full or an > incremental it stays in the pool and the disk space used is not recovered. > > So unless this weeks full is radically different from last weeks full > you're not going to see a big space drop when last weeks goes away. > > John >> -----Original Message----- >> From: Les Mikesell [mailto:[EMAIL PROTECTED] >> Sent: Thursday, December 13, 2007 3:22 PM >> To: [EMAIL PROTECTED] >> Cc: [email protected]; 'John Pettitt' >> Subject: Re: [BackupPC-users] Deleted Host >> >> Rob Ogle wrote: >> >>> Ok. So... >>> If I want to keep one full per week and increment once each day between >>> fulls- is this what my settings should be? >>> >>> FullPeriod: 6.97 >>> FullKeepCnt: 1 >>> FullKeepCntMin: 1 >>> FullAgeMax: 365 >>> >>> IncrPeriod: 0.97 >>> IncrKeepCnt: 8 >>> IncrKeepCntMin: 8 >>> IncrAgeMax: 1 >>> IncrLevels: 1 >>> >> >> >> You'll end up with overlapping fulls, which will probably happen in any >> case since the old one wouldn't be deleted until the new one completes. >> I think that 8'th day of incrementals will keep the old one around >> one more day. Space-wise it probably doesn't matter as long as it is >> gone before the next full happens. >> >> > > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > 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/ > ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ 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/
