There are two ways I use to dynamic backup. One lock table can copy it. Use some think like hotcopy. The only down side can be that if the table is very big the lock can queue two may questions. The other way it to use replication can make the backup from the slave. If it is taking up to an hour are they doing a full systems backup? Simon
-----Original Message----- From: Clemente [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 10:44 To: [EMAIL PROTECTED] Subject: Mandatory server downtime? Hi there, My hosting company tells me that they need to take down the MySQL server every day for 30 to 60 minutes to make a backup. This is the quote: "Please note that mysql is shutdown daily sometime between 3am and 9 am US eastern for 30 minutes to an hour. This is get a good backup of all mysql databases on the server during the daily backup process." Is this normal? This implies that my dynamic generated web site is down during a 2.1% to a 4.2% of the time (not counting any other server down time). I hear that normal down times for web sites are more like 1% or less. Is this really necessary? Does MySQL requires to be shutdown to generate a good backup? Any comments are welcome. Thanks a lot. -- Clemente Zamora GlobalReservas (http://www.clementezamora.com) --------------------------------------------------------------------- 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
