You should take a look at Percona's xtrabackup utility to do this. It
takes a clean snapshot of an innodb database that can be restored on a
target machine in a few minutes, though it does crash recovery at
backup time which can take a while.
Marcus
| Thread |
|---|
| • Copy 70GB ibdata, etc. and server won't start now | Daevid Vincent | 14 Jul |
| • RE: Copy 70GB ibdata, etc. and server won't start now | Gary Smith | 14 Jul |
| • RE: Copy 70GB ibdata, etc. and server won't start now | Daevid Vincent | 14 Jul |
| • Re: Copy 70GB ibdata, etc. and server won't start now | Johnny Withers | 14 Jul |
| • RE: Copy 70GB ibdata, etc. and server won't start now | Gary Smith | 14 Jul |
| • RE: Copy 70GB ibdata, etc. and server won't start now | Daevid Vincent | 15 Jul |
| • Re: Copy 70GB ibdata, etc. and server won't start now | Carlos Proal | 15 Jul |
| • Re: Copy 70GB ibdata, etc. and server won't start now | Carlos Proal | 15 Jul |
| • RE: Copy 70GB ibdata, etc. and server won't start now | Daevid Vincent | 15 Jul |
| • Re: Copy 70GB ibdata, etc. and server won't start now | Carlos Proal | 15 Jul |
| • RE: Copy 70GB ibdata, etc. and server won't start now | Daevid Vincent | 14 Jul |
| • RE: Copy 70GB ibdata, etc. and server won't start now | Gary Smith | 14 Jul |
| • Re: Copy 70GB ibdata, etc. and server won't start now | Carlos Proal | 14 Jul |
| • Re: Copy 70GB ibdata, etc. and server won't start now | Marcus Bointon | 14 Jul |
| • Re: Copy 70GB ibdata, etc. and server won't start now | Todd Lyons | 15 Jul |
