Boniforti Flavio wrote:

> Hello everybody.
> 
> I already asked about creating some reports many months ago, didn't have
> the time to dig into this thing until a few days ago.
> 
> I'll try to explain what my environment is and what my goals are (I hope
> you will be reading 'til the end). So let's start!
> 
> I got my backuppc installed on a Debian Server, which is backing up my
> customers' data using rsync over ssh (using ssh tunnel). I'm retaining 1
> month of backups for each client host.
> 
> My goal: creating a history of backups data, like "time elapsed", backup
> size, file count, etc.
> 
> I know that the "backups" for each single host I back up, contains the
> data I'm hungry for, which is:
> 
> endTime-startTime = backup duration
> nFiles = number of files backed up
> size = total size of files backed up
> 
> I'm actually saving in a separate text file only the *full* backups, as
> their size is more concretely near to a real value.
> 
> What I want to achieve is to have some sort of "database" which grows
> with these values, because I want to know the history of my backups,
> altough I'm keeping only the last 30 backups for my clients. While
> thinking about "database", I came up with the idea to write that data
> into an mysql db, so here I am asking for help/suggestions to get this
> connection done. Is this feasable?
> 
> I'm also actually storing for each backup, using iptables, the actual
> data transfer: each day resetting iptables counters and saving that data
> into a text file. Would like to put that data too into that mysql db,
> which could then be used by many means to extract reports and graphs.
> 
> Any thought/comment will be appreciated.
> 
> Thanks for reading,
> Flavio Boniforti

Hi Flavio,

Late, but hopefully not too late. My response :-)
Do you know the __TOPDIR__/pc/<host>/backups file?
It contains all the values you described above.

I am interested at the measurement with iptables. Would you post it?

Thanks
Matthias
br
Matthias
-- 
Don't Panic


------------------------------------------------------------------------------

_______________________________________________
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/