Phil Stracchino wrote on 05/05/2018 01:22 PM:
At this point your best course of action might be to stop Bacula, drop
and recreate your Bacula database, then restart Bacula.
What I actually did was drop the bacula database and recreate it from
/var/lib/bacula/bacula.sql. That was post upgrade, but the Media table
was good. As it turned out the only thing that actually was not done by
the update_mysql_tables script originally was the updates to Media,
presumably because the running copy was bad.
All is working now, By the way, I wonder if the sql-mode change was
necessary, the update_mysql_table has a whole bunch of DROP DEFAULT for
the time and date columns for Mysql 5.7.
Phil, thanks for your help! Lesson learned, I'll be looking into
backing up mysql properly.
Ken
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
