At 21:21 -0600 11/5/02, Lewis Watson wrote:
Hey MySQL users! I have been using amanda as backup software. It seems that it is working fine as a backup for the MySQL data directory but I am wondering is there a better way to backup up the databases? They are production Db's so I really do not want to stop the server, but isn't this necessary to properly backup up the db directory?
Yes. Taking a backup of a live data directory without taking measures that involve coordination with the server only gives you backups of files that aren't necessarily consistent for database purposes. For example, the server may be maintaining buffered updates that haven't yet been flushed to disk. Backups on such files are not necessarily of any value.
Thanks. Lewis
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
