>>>>> On Tue, 10 Apr 2012 15:27:22 -0400, Phil Stracchino said:
> 
> On 04/10/2012 02:15 PM, Martin Simmons wrote:
> > Sorry, I didn't mean mysqldump on its own.
> > 
> > The MySQL documentation suggests that you can make a backup from the output 
> > of
> > mysqldump plus later binlogs and then use them to restore a database, but 
> > what
> > use is that if it doesn't work with temporary tables?
> > 
> > For this to work, all transactions should either be entirely in the output 
> > of
> > mysqldump or entirely in the later binlogs.  This could probably work if
> > temporary tables are used within a transaction, because hopefully mysqldump
> > will wait for it to finish.  It probably can't work if temporary tables are
> > used without a transaction.
> 
> You shouldn't think of a temporary table as persistent DB data.  Think
> of them instead as part of the transient state of a single ongoing
> transaction.  Is it a reasonable expectation for a DB restore to be able
> to restore any part of the transient state of a transaction that
> happened to be running when the backup was made?  Even if it could,
> where would the results go?
> 
> There's no way to resume an interrupted transaction from the middle, and
> so there's no point in backing up any of its state except to roll back
> anything it's already partly done.  If you want to repeat the
> transaction, you have to restart it from the beginning, which will
> recreate any temporary tables it was using anyway.

OK, so it looks like Bacula's use of temporary tables outside a transaction is
at best incompatible with "live" backups of MySQL and at worst incorrect.

__Martin

------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users