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