From: machiel.richards
Date: November 1 2012 3:53pm
Subject: Re: Mysql backup for large databases
List-Archive: http://lists.mysql.com/mysql/228568
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

V2VsbCwgdGhlIGJpZ2dlc3QgcHJvYmxlbSB3ZSBoYXZlIHRvIGFuc3dlciBmb3IgdGhlIGNsaWVu
dHMgaXMgdGhlIGZvbGxvd2luZzoNCjEuIEJhY2t1cCBtZXRob2QgdGhhdCBkb2Vzbid0IHRha2Ug
bG9uZyBhbmQgZG9uJ3QgaW1wYWN0IHN5c3RlbQ0KMi4gUmVzdG9yZSBuZWVkcyB0byBiZSBkb25l
IG9uIGEgcXVpY2sgYXMgcG9zc2libGUgd2F5IGluIG9yZGVyIHRvIG1pbmltaXplIGRvd250aW1l
Lg0KDQpUaGUgb25lIGNsaWVudCBpcyBydW5uaW5nIG1hc3RlciAtIG1hc3RlciByZXBsaWNhdGlv
biB3aXRoIG1hc3RlciBzZXJ2ZXIgaW4gdXNhLCBhbmQgc2xhdmUgaW4gc291dGggYWZyaWNhLiBU
aGV5IG5lZWQgbWFzdGVyIGJhY2t1cCB0byBiZSBkb25lIGluIHRoZSBzdGF0ZXMuDQoNCg0KU2Vu
dCB2aWEgbXkgQmxhY2tCZXJyeSBmcm9tIFZvZGFjb20gLSBsZXQgeW91ciBlbWFpbCBmaW5kIHlv
dSENCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IFJlaW5kbCBIYXJhbGQgPGgu
cmVpbmRsQHRoZWxvdW5nZS5uZXQ+DQpEYXRlOiBUaHUsIDAxIE5vdiAyMDEyIDE2OjQ5OjQ1IA0K
VG86IG15c3FsQGxpc3RzLm15c3FsLmNvbTxteXNxbEBsaXN0cy5teXNxbC5jb20+DQpTdWJqZWN0
OiBSZTogTXlzcWwgYmFja3VwIGZvciBsYXJnZSBkYXRhYmFzZXMNCg0KZ29vZCBsdWNrDQoNCmkg
d291bGQgY2FsbCBzbmFwc2hvdHMgb24gYSBydW5uaW5nIHN5c3RlbSBtdWNoIG1vcmUgZHVtYg0K
dGhhbiAiaW5ub2RiX2ZsdXNoX2xvZ19hdF90cnhfY29tbWl0ID0gMiIgb24gc3lzdGVtcyB3aXRo
DQoxMDAlIHN0YWJsZSBwb3dlciBpbnN0ZWFkIHdhc3RlIElPUFMgb24gc2hhcmVkIHN0b3JhZ2Vz
DQoNCkFtIDAxLjExLjIwMTIgMTY6NDUsIHNjaHJpZWIgU2luZ2VyIFdhbmc6DQo+IEFzc3VtaW5n
IHlvdSdyZSBub3QgZG9pbmcgZHVtYiBzdHVmZiBsaWtlIGlubm9kYl9mbHVzaF9sb2dfYXRfdHg9
MCBvciAyIGFuZCBldGMsIHlvdSBzaG91bGQgYmUgZmluZS4gV2UgaGF2ZSBiZWVuDQo+IHVzaW5n
IHRoZSB0cmlvOiBmbHVzaCB0YWJsZXMgd2l0aCByZWFkIGxvY2ssIHhmc19mcmVlemUsIHNuYXBz
aG90IGZvciBtb250aHMgbm93IHdpdGhvdXQgYW55IGlzc3Vlcy4gQW5kIHdlIHRlc3QNCj4gdGhl
IGJhY2t1cHMgKHdlIGxvYWQgdGhlIGJhY2t1cCBpbnRvIGEgc3RhZ2luZyBvbmNlIGEgZGF5LCBh
bmQgZGV2IG9uY2UgYSB3ZWVrKSANCj4gDQo+IE9uIFRodSwgTm92IDEsIDIwMTIgYXQgMTE6NDEg
QU0sIFJlaW5kbCBIYXJhbGQgPGgucmVpbmRsQHRoZWxvdW5nZS5uZXQgPG1haWx0bzpoLnJlaW5k
bEB0aGVsb3VuZ2UubmV0Pj4gd3JvdGU6DQo+IA0KPiAgICAgPiBXaHkgZG8geW91IG5lZWQgZG93
bnRpbWU/DQo+IA0KPiAgICAgYmVjYXVzZSBteXNxbGQgaGFzIG1hbnkgYnVmZmVycyBpbiBtZW1v
cnkgYW5kIHRoZXJlDQo+ICAgICBpcyBubyBhdG9taWMgImZsdXNoIGJ1ZmZlcnMgaW4gZGFlbW9u
IGFuZCBmcmVlemUgYmFja2VuZCBGUyINCj4gDQo+ICAgICBzaG9ydCBhZ28gdGhlcmUgd2FzIGEg
Z3V5IG9uIHRoaXMgbGlzdCB3aGljaCBoYWQgdG8gcmVhbGl6ZQ0KPiAgICAgdGhpcyB0aGUgaGFy
ZCB3YXkgd2l0aCBhIGNvcnJ1cHQgc2xhdmUgdGFrZW4gZnJvbSBhIHNuYXBzaG90DQo+IA0KPiAg
ICAgdGhhdCdzIHdoeSBpIHdvdWxkIEFMV0FZUyBkbyBtYXN0ZXIvc2xhdmUgd2hhdCBtZWFucyBP
TkUgdGltZQ0KPiAgICAgZG93biAocnN5bmM7IHN0b3AgbWFzdGVyOyByc3luYzsgc3RhcnQgbWFz
dGVyKSBmb3IgYSBzbWFsbA0KPiAgICAgdGltZXdpbmRvdyBhbmQgYWZ0ZXIgdGhhdCB5b3UgY2Fu
IHN0b3AgdGhlIHNsYXZlLCB0YWtlIGENCj4gICAgIDEwMCUgY29uc2lzdGVudCBiYWNrdXAgb2Yg
aXQncyB3aG9sZSBkYXRhZGlyIGFuZCBzdGFydA0KPiAgICAgdGhlIHNsYXZlIGFnYWluIHdoaWNo
IHdpbGwgZG8gYWxsIHRyYW5zYWN0aW9ucyBmcm9tIHRoZQ0KPiAgICAgYmluYXJ5bG9nIGhhcHBl
bmVkIGluIHRoZSBtZWFudGltZQ0KDQoNCg==