>>>>> On Tue, 10 Apr 2012 11:15:29 -0400, Phil Stracchino said: > > On 04/10/2012 10:51 AM, Joe Nyland wrote: > > I'm a bit ashamed to admit I'm still battling this! I've removed > > '--delete-master-logs' from my mysqldump line, but it hasn't helped. > > > > For some reason, it seems as if the dump does not contain any mention > > of the temporary tables being created, neither do the binary logs, > > however there are statements which refer to bacula.batch, as if it > > should be there. > > > > Could it be that these statements refer to a bacula.batch table which > > was created by another thread prior to the mysql dump being created? > > ...and that's why the "CREATE TEMPORARY TABLE bacula.batch" statement > > is not in the binary logs after the full backup. Surely, if this were > > the case, the bacula.batch table sowuld be included in the dump would > > they not? > > No, because a dump will not contain temporary tables. So if you restore > a dump and a set of binlogs that contain transactions referring to > temporary tables extant when you created the dump, yes, those > transactions are irretrievably orphaned.
Is mysql's backup procedure really that broken? Or maybe the problem is caused by Bacula misusing temporary tables (e.g. without a transaction)? __Martin ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
