Use the command line utility dropdb instead of the psql command

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

diff --git a/bacula/src/cats/update_mysql_tables.in b/bacula/src/cats/update_mysql_tables.in
index 7767308c52464b72489849bc3fe31c0cb9e2e0f7..c87955612abc36f463f0396c69c32105e7e8f281 100755 (executable)
--- a/bacula/src/cats/update_mysql_tables.in
+++ b/bacula/src/cats/update_mysql_tables.in
@@ -52,7 +52,8 @@ CREATE TABLE BaseFiles (
    PRIMARY KEY(BaseId)
    );
 
-UPDATE Version SET VersionId=7;
+DELETE FROM Version;
+INSERT INTO Version (VersionId) VALUES (7);
 
 END-OF-DATA
 then