On 05/05/18 12:55, Ken Mandelberg wrote: > Phil Stracchino wrote on 05/05/2018 12:48 PM: >> >> I would definitely restore the Bacula database from a recent DB dump >> (you *do* run regular DB dumps, right...?) and rerun the upgrade script. >> >> > Meaculpa, if its not a default I don't do it. All I'm aware of is the > two jobs, the catalog and the files job.
OK, I'm not talking about jobs within Bacula, I'm talking about doing regular logical dumps of the database itself. You should probably actually have your MySQL database directory excluded from Bacula, because in general, backing up SQL databases at the file level is not useful because it is not guaranteed to get a consistent state of the entire database. (Because the database is stored in multiple files, and there WILL be time skew between the first and last files backed up, during which time data in the database may have changed, so you kback up parts of the database in one state and parts of it in another and ... you end up with a corrupted, unrestorable database.) At this point your best course of action might be to stop Bacula, drop and recreate your Bacula database, then restart Bacula. It's your call whether to delete your existing Bacula volumes and start over, or re-populate as much as you can of the Bacula DB by bscanning *all* of the volumes comprising your last set of *full* backups, *in order as a single bscan task*. You probably also want to look into setting up nightly dumps of your database, and backing up those dumps instead of the live database files. I would recommend you look into mydumper for this purpose. It is a much better tool than mysqldump. You might be tempted to load a script like mysqlbackup from sourceforge or some such place. It's up to you, but the truth is, speaking as a MySQL database engineer/analyst, most of them are pretty awful. But they're better than nothing. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ 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