On 04/13/2012 01:02 PM, Martin Simmons wrote:
>>>>>> On Tue, 10 Apr 2012 15:27:22 -0400, Phil Stracchino said:
>> 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.

I'm not understanding what you think is "incorrect" here.

Let's try it this way:  How are you thinking that temporary tables
should work, and what do you think "should happen" if you try to restore
your Bacula catalog to a state that represents a point in the middle of
a job that is not currently running?


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
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