<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Sep 4, 2007, at 11:17 PM, Bill Williamson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><span class="gmail_quote">On 9/5/07, <b class="gmail_sendername"><a href="mailto:clemens@dwf.com">clemens@dwf.com</a></b> <<a href="mailto:clemens@dwf.com">clemens@dwf.com</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Is there any advantage in using one of the mysql backup programs over<br>just taring up /var/lib/mysql/mysql and /var/lib/mysql/mythconverg ? </blockquote> <div> </div> <div> </div> <div>-Are you completely shutting down the database before tarring those up?</div> <div>-Are you guaranteeing that you will be using the EXACT same version of MySQL if you need to do a restore?</div> <div> </div> <div>You should ignore the existance of ANY database raw files kept on a filesystem. Pretend they don't exist.</div></div></blockquote></div><br><div>I also like that when I dump my database, it's human-readable so if I ever need to restore, I can actually see at what point I'm restoring and if I need to make any modifications before I restore, I can do that by hand.</div><div><br></div></body></html>