On Tuesday 06 December 2005 02:44, Rushowr wrote: > Anyone have a rundown of the relationships that bacula uses between tables > in the mysql db? I'm trying to manually track down a file and ALL jobs > within a date range that saved it, but the database is so spread out, it > would be beautiful if I could come across this. I could have sworn I saw it > online, but can't find it, and the PDF of documentation doesn't have it > either.. > > Thanks to any who can help. (A SQL query that would find file FINDMEX.sql > and all jobs that saved that file in the date range STARTDATE to ENDDATE > would be even more awesome).
There is one option of the query command that will do something similar to what you want. The old tech doc on the database is in the developer's manual on the web site. -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users