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

PIRAMIDE INFORMATICA SAGL
Via Ballerini 21
6600 Locarno
Switzerland
Phone: +41 91 751 68 81
Fax: +41 91 751 69 14
URL: http://www.piramide.ch
E-mail: flavio AT piramide DOT ch 

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