Hello Phil,
In the next major version of Bacula (later this year) I will be
releasing the Enterprise MySQL backup plugin. I will be interested to
hear what you have to say about it.
Best regards,
Kern
On 05/05/2018 07:22 PM, Phil Stracchino wrote:
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.
------------------------------------------------------------------------------
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
