Guys,
I've been happily running bacula at home, and usualy it's pretty
predictable about the size of data backed up each night, but last
night I had an incremental run for a specfic client which used 8Gb of
data, when I normally expect around 500mb or so.  

Is there an easy mysql query I can use to:

a) find the largest file(s) backed up for a particular jobid?

b) report on the size of a directory and all the files backed up under
   it?  The idea being if that somehow I touched a million small files
   by accident, I can still find out what went on because I can sum up
   the change(s) on a per-directory basis.

You can see what I'm driving at by looking at these job results:

  Terminated Jobs:
   JobId  Level    Files      Bytes   Status   Finished        Name 
  ======================================================================
    7157  Diff     53,346    12.46 G  OK       27-Mar-11 02:00 jfsnew-fd
    7158  Full          1    158.0 M  OK       27-Mar-11 02:44
   BackupCatalog
    7160  Incr      2,775    1.244 G  OK       28-Mar-11 01:10 jfsnew-fd
    7161  Full          1    158.4 M  OK       28-Mar-11 01:14
   BackupCatalog
    7163  Incr        664    457.0 M  OK       29-Mar-11 01:10 jfsnew-fd
    7164  Full          1    158.5 M  OK       29-Mar-11 01:11
   BackupCatalog
    7166  Incr        727    423.0 M  OK       30-Mar-11 01:10 jfsnew-fd
    7167  Full          1    158.6 M  OK       30-Mar-11 01:11
   BackupCatalog
    7169  Incr     64,404    8.092 G  OK       31-Mar-11 01:21 jfsnew-fd
    7170  Full          1    167.8 M  OK       31-Mar-11 01:46
   BackupCatalog

Notice how the differential done last weekend backed up 53,000+ files,
and 12gb.  But last night it was 64,000+ files and 8gb.  I'm wondering
what happened....  I have my suspicions, but now I'm trying to find
the culprits, if only so I can understand what's happening.

Thanks,
John


------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users