Hi,
I've been using Bacula for a while now and I have a backup procedure in place
for my MySQL databases, where I perform a full (dump) backup nightly, then
incremental (bin log) backups every hour through the day to capture changes.
I basically have a script which I have written which is run as a 'RunBeforeJob'
from backup and runs either a mysqldump if the backup level is full, or flushes
the bin logs if the level is incremental.
I'm in the process of performing some test restores from these backups, as I
would like to know the procedure is working correctly.
I have no issue restoring the files from Bacula, however I'm having some issues
restoring my catalog MySQL database from the binary logs created by MySQL.
Specifically, I am getting messages like:
ERROR 1146 (42S02) at line 105: Table 'bacula.batch' doesn't exist
when I try to replay my log files against the database after it's been restore
from the dump file. As far as I know the batch table is a temporary table
created when inserting file attributes into the catalog during/after a backup
job. I would have hoped, however, the creation of this table would have been
included in either my database/earlier in my bin log.
I believe this may be related to another thread on the list at the moment
titled "Catalog backup while job running?" as this is, in effect what I am
doing - a full database dump whilst other jobs are running, but my reason for
creating a new thread is that I am not getting any errors in my backup jobs, as
the OP of the other thread is - I'm simply having issues rebuilding my database
after restoring the said full dump.
I would like to know if anyone is currently backing up their catalog database
in such a way, and if so how they are overcoming this issue when restoring. My
reason for backing up my catalog using binary logging is so that I can perform
a point-in-time recovery of the catalog, should I loose it.
Any input anyone can offer would be greatly appreciated.
Thanks,
Joe
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|