MySQL and amanda
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? 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
RE: MySQL and amanda
I was under the impression that hotbackup was only available with innodb tables where do you get amanda from? Alan -Original Message- From: Lewis Watson [mailto:lists;visionsix.com] Sent: Wednesday, 6 November 2002 14:22 To: mysql Subject: MySQL and amanda 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? 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 - 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
Re: MySQL and amanda
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