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: [email protected] ------------------------------------------------------------------------------ _______________________________________________ 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/
