Re: Backups with MySQL/InnoDB

2006-05-08 Thread Greg 'groggy' Lehey
On Sunday, May 07, 2006 6:14 PM, Greg 'groggy' Lehey wrote: > On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote: >> What are people doing for backups on very large MySQL/InnoDB >> databases? Say for databases greater than 200 GB. Curious about >> the backup methods, procedures, and f

RE: Backups with MySQL/InnoDB

2006-05-08 Thread Logan, David (SST - Adelaide)
--- -Original Message- From: Duzenbury, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 May 2006 6:39 AM To: mysql@lists.mysql.com Subject: RE: Backups with MySQL/InnoDB > -Original Message- > From: Daniel da

RE: Backups with MySQL/InnoDB

2006-05-08 Thread Duzenbury, Rich
> -Original Message- > From: Daniel da Veiga [mailto:[EMAIL PROTECTED] > Sent: Monday, May 08, 2006 1:55 PM > To: mysql@lists.mysql.com > Subject: Re: Backups with MySQL/InnoDB > > On 5/8/06, David Hillman <[EMAIL PROTECTED]> wrote: > > On May 7, 2006,

Re: Backups with MySQL/InnoDB

2006-05-08 Thread Daniel da Veiga
On 5/8/06, David Hillman <[EMAIL PROTECTED]> wrote: On May 7, 2006, at 11:29 PM, Robert DiFalco wrote: > Fast, incremental, compressed, and no max-size limitations. Must be > transaction safe; able to run while transactions are going on without > including any started after the backup began; the

Re: Backups with MySQL/InnoDB

2006-05-08 Thread David Hillman
On May 7, 2006, at 11:29 PM, Robert DiFalco wrote: Fast, incremental, compressed, and no max-size limitations. Must be transaction safe; able to run while transactions are going on without including any started after the backup began; the usual stuff. Incremental, transaction safe, compresse

RE: Backups with MySQL/InnoDB

2006-05-07 Thread Robert DiFalco
nt: Sunday, May 07, 2006 6:14 PM To: Robert DiFalco Cc: mysql@lists.mysql.com Subject: Re: Backups with MySQL/InnoDB On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote: > What are people doing for backups on very large MySQL/InnoDB databases? > Say for databases greater than 200 G

Re: Backups with MySQL/InnoDB

2006-05-07 Thread Greg 'groggy' Lehey
On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote: > What are people doing for backups on very large MySQL/InnoDB databases? > Say for databases greater than 200 GB. Curious about the backup methods, > procedures, and frequency. A second question, but not for the first time: how would