Hi All, I had a perfectly good Bacula 9.6.6 Server and upgraded Bacula 9.6.6 to the new Bacula 11.03 and now my bacula-dir will not start. 🙁 Also the database upgrade was not done automatically even though I used slanesh-Bacula REPO to do the upgrade. I tried updating the database manually by running the scripts provided, I'm getting the following error: ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS JobId on File' at line 1 Update of Bacula MySQL tables from 16 to 1017 failed.
Please see full details below when I run the command to manually update the database. I am currently using MariDB as my database ( I never had any issues with it until now) root@baculaserver bacula]# ./update_mysql_tables -u root -p This script will update a Bacula MySQL database from any from version 12-15 or 1014-1021 to version 1022 which is needed to convert from any Bacula Enterprise version 4.0.x or later to version 12.4.x or Bacula Community versions 5.0.x, 5.2.x, 7.4.x, 9.x.x to Community version 11.0 Depending on the current version of your catalog, you may have to run this script multiple times Enter password: Enter password: ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS JobId on File' at line 1 Update of Bacula MySQL tables from 16 to 1017 failed. Any help appreciated. Thanks, Humphrey
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
