From: Rick James
Date: November 1 2012 4:04pm
Subject: RE: Mysql backup for large databases
List-Archive: http://lists.mysql.com/mysql/228570
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1490E7A2A8@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

QXJlIGJvdGggTWFzdGVycyB3cml0ZWFibGU/ICBJZiBzbywgeW91IGhhdmUgZXZlbiB3b3JzZSBw
cm9ibGVtcy4NCg0KSWYgbm90LCB0aGVuIGNvbnNpZGVyIHN3aXRjaGluZyB0byBvbmUgbWFzdGVy
IHdpdGggMiBzbGF2ZXMgYW5kIHVzZSBNSEEgZm9yIGZhaWxvdmVyLCBldGMuICBXaXRoIHRoYXQs
IHlvdSBjYW4gc2VhbWxlc3NseSBhbmQgbmVhcmx5IGluc3RhbnRseSBzd2l0Y2ggdG8gYW55IHNs
YXZlLiAgSXQgZG9lcyBub3QgaW52b2x2ZSBhICJyZXN0b3JlIiwgYnV0IGdldHMgeW91IGFsaXZl
IHZlcnkgcXVpY2tseSBieSBzd2l0Y2hpbmcgdG8gYW5vdGhlciBtYWNoaW5lLg0KDQpGb3IgeW91
ciBzaXR1YXRpb246DQpNYXN0ZXIgKGxvY2FsKSwgYW5vdGhlciBTbGF2ZSBzb21ld2hlcmUgZWxz
ZSBidXQgbmVhcmJ5LCBTbGF2ZSBpbiBTb3V0aCBBZnJpY2EuDQpUaGVuLCBkdXJpbmcgZmFpbG92
ZXIsIHByZWZlciB0aGUgbmVhcmJ5IHNsYXZlLiAgQWZ0ZXIgZmFpbGluZyBvdmVyLCB3b3JyeSBh
Ym91dCAnZml4aW5nJyB0aGUgZGVhZCBNYXN0ZXIgYXQgeW91ciBsZWlzdXJlLg0KDQpXaGF0IGlz
IHRoZSBwdXJwb3NlIG9mIHRoZSByZXN0b3JlPw0KMS4gIFJlY292ZXJ5IGZyb20gZGVhZCBNYXN0
ZXI/ICAtLSBNSEEgbWF5IGJlIGJlc3QNCjIuICBSZWNvdmVyeSB0byBzb21lIHByZXZpb3VzIHBv
aW50LWluLXRpbWU/ICAtLSBtdWNoIG9mIHRoZSBkaXNjdXNzaW9uIGhhcyBjZW50ZXJlZCBhcm91
bmQgdGhpcyBvYnNjdXJlIHVzZQ0KMy4gIEJ1aWxkaW5nIHN0YWdpbmcvcWEvZGV2L2V0YyBtYWNo
aW5lIHRoYXQgbWF0Y2hlcyB0aGUgbWFzdGVyIGF0IHNvbWUgcG9pbnQgaW4gdGltZT8NClRoZXJl
IGFyZSBkaWZmZXJlbnQgc29sdXRpb25zIHRvIGVhY2ggb2YgdGhlc2UuDQoNCiMzIGlzIHByb2Jh
Ymx5IGJlc3QgZG9uZSBieSBoYXZpbmcgYSBzbGF2ZSBoYW5naW5nIG9mZiB0aGUgTWFzdGVyLCB0
aGVuIGRpc2Nvbm5lY3RpbmcgaXQgd2hlbiB5b3Ugd2FudCBpdC4gIElmIHlvdSBtdWNrIHdpdGgg
dGhlIGRhdGEsIGl0IHdpbGwgbmVlZCBhIGxvbmcgcmVzdG9yZTsgaWYgbm90LCBpdCBpcyBhIG1h
dHRlciBvZiByZWNvbm5lY3RpbmcgYW5kIGxldHRpbmcgcmVwbGljYXRpb24gY2F0Y2ggdXAuDQoN
Cj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4gRnJvbTogbWFjaGllbC5yaWNoYXJkc0Bn
bWFpbC5jb20gW21haWx0bzptYWNoaWVsLnJpY2hhcmRzQGdtYWlsLmNvbV0NCj4gU2VudDogVGh1
cnNkYXksIE5vdmVtYmVyIDAxLCAyMDEyIDg6NTQgQU0NCj4gVG86IFJlaW5kbCBIYXJhbGQ7IG15
c3FsQGxpc3RzLm15c3FsLmNvbQ0KPiBTdWJqZWN0OiBSZTogTXlzcWwgYmFja3VwIGZvciBsYXJn
ZSBkYXRhYmFzZXMNCj4gDQo+IFdlbGwsIHRoZSBiaWdnZXN0IHByb2JsZW0gd2UgaGF2ZSB0byBh
bnN3ZXIgZm9yIHRoZSBjbGllbnRzIGlzIHRoZQ0KPiBmb2xsb3dpbmc6DQo+IDEuIEJhY2t1cCBt
ZXRob2QgdGhhdCBkb2Vzbid0IHRha2UgbG9uZyBhbmQgZG9uJ3QgaW1wYWN0IHN5c3RlbSAyLiBS
ZXN0b3JlDQo+IG5lZWRzIHRvIGJlIGRvbmUgb24gYSBxdWljayBhcyBwb3NzaWJsZSB3YXkgaW4g
b3JkZXIgdG8gbWluaW1pemUgZG93bnRpbWUuDQo+IA0KPiBUaGUgb25lIGNsaWVudCBpcyBydW5u
aW5nIG1hc3RlciAtIG1hc3RlciByZXBsaWNhdGlvbiB3aXRoIG1hc3RlciBzZXJ2ZXIgaW4NCj4g
dXNhLCBhbmQgc2xhdmUgaW4gc291dGggYWZyaWNhLiBUaGV5IG5lZWQgbWFzdGVyIGJhY2t1cCB0
byBiZSBkb25lIGluIHRoZQ0KPiBzdGF0ZXMuDQo+IA0KPiANCj4gU2VudCB2aWEgbXkgQmxhY2tC
ZXJyeSBmcm9tIFZvZGFjb20gLSBsZXQgeW91ciBlbWFpbCBmaW5kIHlvdSENCj4gDQo+IC0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IFJlaW5kbCBIYXJhbGQgPGgucmVpbmRsQHRo
ZWxvdW5nZS5uZXQ+DQo+IERhdGU6IFRodSwgMDEgTm92IDIwMTIgMTY6NDk6NDUNCj4gVG86IG15
c3FsQGxpc3RzLm15c3FsLmNvbTxteXNxbEBsaXN0cy5teXNxbC5jb20+DQo+IFN1YmplY3Q6IFJl
OiBNeXNxbCBiYWNrdXAgZm9yIGxhcmdlIGRhdGFiYXNlcw0KPiANCj4gZ29vZCBsdWNrDQo+IA0K
PiBpIHdvdWxkIGNhbGwgc25hcHNob3RzIG9uIGEgcnVubmluZyBzeXN0ZW0gbXVjaCBtb3JlIGR1
bWIgdGhhbg0KPiAiaW5ub2RiX2ZsdXNoX2xvZ19hdF90cnhfY29tbWl0ID0gMiIgb24gc3lzdGVt
cyB3aXRoIDEwMCUgc3RhYmxlIHBvd2VyDQo+IGluc3RlYWQgd2FzdGUgSU9QUyBvbiBzaGFyZWQg
c3RvcmFnZXMNCj4gDQo+IEFtIDAxLjExLjIwMTIgMTY6NDUsIHNjaHJpZWIgU2luZ2VyIFdhbmc6
DQo+ID4gQXNzdW1pbmcgeW91J3JlIG5vdCBkb2luZyBkdW1iIHN0dWZmIGxpa2UgaW5ub2RiX2Zs
dXNoX2xvZ19hdF90eD0wIG9yDQo+ID4gMiBhbmQgZXRjLCB5b3Ugc2hvdWxkIGJlIGZpbmUuIFdl
IGhhdmUgYmVlbiB1c2luZyB0aGUgdHJpbzogZmx1c2gNCj4gPiB0YWJsZXMgd2l0aCByZWFkIGxv
Y2ssIHhmc19mcmVlemUsIHNuYXBzaG90IGZvciBtb250aHMgbm93IHdpdGhvdXQgYW55DQo+ID4g
aXNzdWVzLiBBbmQgd2UgdGVzdCB0aGUgYmFja3VwcyAod2UgbG9hZCB0aGUgYmFja3VwIGludG8g
YSBzdGFnaW5nDQo+ID4gb25jZSBhIGRheSwgYW5kIGRldiBvbmNlIGEgd2VlaykNCj4gPg0KPiA+
IE9uIFRodSwgTm92IDEsIDIwMTIgYXQgMTE6NDEgQU0sIFJlaW5kbCBIYXJhbGQgPGgucmVpbmRs
QHRoZWxvdW5nZS5uZXQNCj4gPG1haWx0bzpoLnJlaW5kbEB0aGVsb3VuZ2UubmV0Pj4gd3JvdGU6
DQo+ID4NCj4gPiAgICAgPiBXaHkgZG8geW91IG5lZWQgZG93bnRpbWU/DQo+ID4NCj4gPiAgICAg
YmVjYXVzZSBteXNxbGQgaGFzIG1hbnkgYnVmZmVycyBpbiBtZW1vcnkgYW5kIHRoZXJlDQo+ID4g
ICAgIGlzIG5vIGF0b21pYyAiZmx1c2ggYnVmZmVycyBpbiBkYWVtb24gYW5kIGZyZWV6ZSBiYWNr
ZW5kIEZTIg0KPiA+DQo+ID4gICAgIHNob3J0IGFnbyB0aGVyZSB3YXMgYSBndXkgb24gdGhpcyBs
aXN0IHdoaWNoIGhhZCB0byByZWFsaXplDQo+ID4gICAgIHRoaXMgdGhlIGhhcmQgd2F5IHdpdGgg
YSBjb3JydXB0IHNsYXZlIHRha2VuIGZyb20gYSBzbmFwc2hvdA0KPiA+DQo+ID4gICAgIHRoYXQn
cyB3aHkgaSB3b3VsZCBBTFdBWVMgZG8gbWFzdGVyL3NsYXZlIHdoYXQgbWVhbnMgT05FIHRpbWUN
Cj4gPiAgICAgZG93biAocnN5bmM7IHN0b3AgbWFzdGVyOyByc3luYzsgc3RhcnQgbWFzdGVyKSBm
b3IgYSBzbWFsbA0KPiA+ICAgICB0aW1ld2luZG93IGFuZCBhZnRlciB0aGF0IHlvdSBjYW4gc3Rv
cCB0aGUgc2xhdmUsIHRha2UgYQ0KPiA+ICAgICAxMDAlIGNvbnNpc3RlbnQgYmFja3VwIG9mIGl0
J3Mgd2hvbGUgZGF0YWRpciBhbmQgc3RhcnQNCj4gPiAgICAgdGhlIHNsYXZlIGFnYWluIHdoaWNo
IHdpbGwgZG8gYWxsIHRyYW5zYWN0aW9ucyBmcm9tIHRoZQ0KPiA+ICAgICBiaW5hcnlsb2cgaGFw
cGVuZWQgaW4gdGhlIG1lYW50aW1lDQo+IA0KDQo=