On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote: > Dear Jim, > > Re: your post at http://lists.mysql.com/mysql/189058, why bother > creating the mysqldump if you already have the snapshot? Why not just > backup the snapshot? > > (I'd have hit reply online but didn't see a Reply button and didn't want > to bother with joining the forum yet.)
George, I think it's ok to post to the list even if one is not not a subscribed member -- perhaps someone will correct me if this is wrong. Unless you have a personal message, or have been specifically asked to communicate something offlist, the benefit of posting to the list is that everybody gets to learn (and ask). Now, to respond to your question.. The output of mysqldump *is* the backup. If the db goes away, it can be restored with (something like) "mysql <dumpfile.2005-09-01". The dump operation is run periodically, and some number of back versions can be kept around (or offloaded) for archival value. Anyway, that expresses my intention. It is admittedly and intentionally a simple-minded backup strategy -- I am hopeful that more experienced list contributors will critique the idea or suggest improvements. ..jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
