Print block errors once + add RunAfterFailedJob + improve db_find_job_start_time...

[bacula/bacula] / bacula / src / cats / drop_mysql_tables.in

diff --git a/bacula/src/cats/drop_mysql_tables.in b/bacula/src/cats/drop_mysql_tables.in
index 0dfaefb2de4c981f0d3a8b04c568c23318959a52..ff97be8fadbfc86af903ac0b69e3eab88bae25e5 100644 (file)
--- a/bacula/src/cats/drop_mysql_tables.in
+++ b/bacula/src/cats/drop_mysql_tables.in
@@ -1,10 +1,10 @@
 #!/bin/sh
 #
-# shell script to delete Bacula tables
+# shell script to delete Bacula tables for MySQL
 
 bindir=@SQL_BINDIR@
 
-if $bindir/mysql <<END-OF-DATA
+if $bindir/mysql $* <<END-OF-DATA
 USE bacula;
 DROP TABLE IF EXISTS Filename;
 DROP TABLE IF EXISTS Path;
@@ -18,10 +18,14 @@ DROP TABLE IF EXISTS Pool;
 DROP TABLE IF EXISTS MultiVolume;
 DROP TABLE IF EXISTS FileSave;  
 DROP TABLE IF EXISTS FileSet;  
+DROP TABLE IF EXISTS Version;
+DROP TABLE IF EXISTS Counters;
+DROP TABLE IF EXISTS BaseFiles;
+DROP TABLE IF EXISTS UnsavedFiles;
 END-OF-DATA
 then
-   echo "Deletion of Bacula tables succeeded."
+   echo "Deletion of Bacula MySQL tables succeeded."
 else
-   echo "Deletion of Bacula tables failed."
+   echo "Deletion of Bacula MySQL tables failed."
 fi
 exit 0