Posted by: Anonymous Coward
on May 30, 2007 08:36 AM
You may be saying "yeah, but the backup took 1 second for all 57 tables." True, but we don't know how much data was in those 57 tables. How long does it take you to copy 100 megs of data? 100 gigs?
This is a good point, and it's why I store my mysql data on an lvm logical volume. I can flush the tables, create a snapshot of the logical volume, and then unlock the tables all in under a second regardless of the data size. I then have as long as I want to backup the data.
FWIW I found it quite easy to roll my own script, rather than using one of the ones mentioned in the article.
Learn about Linux
Download Linux
Get Linux help
Re:There's a lot more to it than that
Posted by: Anonymous Coward on May 30, 2007 08:36 AMYou may be saying "yeah, but the backup took 1 second for all 57 tables." True, but we don't know how much data was in those 57 tables. How long does it take you to copy 100 megs of data? 100 gigs?
This is a good point, and it's why I store my mysql data on an lvm logical volume. I can flush the tables, create a snapshot of the logical volume, and then unlock the tables all in under a second regardless of the data size. I then have as long as I want to backup the data.
FWIW I found it quite easy to roll my own script, rather than using one of the ones mentioned in the article.
#