you must stop the sql database before backuping it up OR you must export
data from it. you could put a client command and used a shared key ssh
session to launch a script to stop mysql before the backup and start it with
the post backup script.
back to the original question. you could create another host entry with a
client alias to the real host and set it to backup that mysql directory and
put increamentals at a high value and change full backups to .97, then
change your full keep count to the appropriate number for your needs and
change the incremental keep count to 0.
On Dec 14, 2007 9:36 AM, Gene Horodecki <[EMAIL PROTECTED]> wrote:
> 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/
>
-------------------------------------------------------------------------
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/
