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

John> Is there an easy mysql query I can use to:

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

Ok, I've googled, read back in the archives about the File.LStat field
and how the file size is in a strange Base64 (almost) encodiing which
needs to be hacked on to get out the sizes.

Looks like I'll just need to:

1. write a perl script to read in a jobid, then pull out the files
from that job.
2. For each file, pull out the File.LStat field and decode the info.
3. And finally then I can search for the largest file(s).  

I'll post something when I'm done.  I'd prefer to do it in mysql
directly, but it looks too funky to parse the string properly without
writing really crazy (to me!) SQL procedures or cursors.  Not worth
it.

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