On 10/08/10 18:09, Attila Fülöp wrote: > Phil Stracchino wrote: >> ...Then again, I could have just made a stupid, trivial configuration >> error on the secondary MySQL server I was loading the restored shapshots >> onto. But none of us ever do that, do we...? > > Phil, > > I don't thinks so. I'm using a similar approach to back up MySQL on ZFS and > I'm seeing "db not cleanly shutdown" and "replaying logs" messages after > starting the cloned db. Looking at zetaback they essentialy do the same and > claim it should work. I had no time to delve deeper into this but at least > the generated dumps look good, so right now I'm ignoring this problem. ;-)
Yes, I'm seeing a little recovery when loading a restored DB, now that I have the second mysqld correctly configured. It appears to only affect a handful of the most recent transactions (unsurprisingly). But once I recognized and fixed my configuration error, the ugly database corruption I thought I was seeing just completely went away. The problem wasn't that the databases were being corrupted, so much as that I'd failed to configure log-bin correctly, so mysqld couldn't find the binary logs to recover the inconsistent transactions from. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 [email protected] [email protected] [email protected] Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
