Re: tarsnap and mysql best practice

2014-04-07 Thread cyryl
Hi, I use mysqlhotcopy with good results. I even tried backing up the db directory without hotcopy'ing it to some temp and suprisingly this also works, however this db is not particularly busy.

Re: Tolerating network errors

2014-04-07 Thread Colin Percival
Hi Luke (& list), On 04/07/14 01:32, Luke Plant wrote: > Thanks for the reply. Sorry I didn't notice "--recover" in the man page. > It did succeed in removing the error when doing --list-archives, but > unfortunately the output from that command was empty, so it looks like > no checkpoint was save

Re: tarsnap and mysql best practice

2014-04-07 Thread Emre Hasegeli
Willem de Groot : > Hi & thanks to Colin for making tarsnap! > > Perhaps this mail belongs on a MySQL list, but as this should be a fairly > common use case for tarsnap users, I hope a tarsnap+mysql best practice has > evolved that I could not find ;) As it is not a MySQL list, I can safely su

Re: Tolerating network errors

2014-04-07 Thread Luke Plant
Hi Colin, Thanks for the reply. Sorry I didn't notice "--recover" in the man page. It did succeed in removing the error when doing --list-archives, but unfortunately the output from that command was empty, so it looks like no checkpoint was saved. Thanks, Luke On 07/04/14 01:27, Colin Percival

Re: tarsnap and mysql best practice

2014-04-07 Thread Arnt Gulbrandsen
I see mysql has PITR now. If your version has that and you can enable it, you may be able to get away with backing up the database while it's running. May. Arnt

Re: tarsnap and mysql best practice

2014-04-07 Thread Jacques-D. Piguet
On 06. 04. 14 14:32, Willem de Groot wrote: Hi & thanks to Colin for making tarsnap! Perhaps this mail belongs on a MySQL list, but as this should be a fairly common use case for tarsnap users, I hope a tarsnap+mysql best practice has evolved that I could not find ;) Does anyone successfully