James G. Sack (jim) wrote:
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?
[...]
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.
Yes, but can't you also save your snapshot instead, then, when/if you
want, restore it,
"4. mount the snapshot
5. load a second database server daemon accessing the db within the
snapshot (with a suitable alternate my.cnf file)
6. perform mysqldump operation on the snapshot-db" ??
thx,
George
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
