add bacula hints
authorMartin Zobel-Helas <zobel@ftbfs.de>
Fri, 2 Feb 2018 13:48:28 +0000 (14:48 +0100)
committerMartin Zobel-Helas <zobel@ftbfs.de>
Fri, 2 Feb 2018 13:48:28 +0000 (14:48 +0100)
Signed-off-by: Martin Zobel-Helas <zobel@ftbfs.de>
input/howto/bacula-hints.mdwn [new file with mode: 0644]

diff --git a/input/howto/bacula-hints.mdwn b/input/howto/bacula-hints.mdwn
new file mode 100644 (file)
index 0000000..0be38ce
--- /dev/null
@@ -0,0 +1,8 @@
+== useful bacula commands ==
+
+ * find out what was in a backup run
+   * get the job-id from the bacula mail
+   * run the following on bacula database (currently bmdb1.debian.org)
+```
+select path,name from filename inner join file on filename.filenameid=file.filenameid inner join path on path.pathid=file.pathid where file.jobid=$JOBID;
+```