Run your database from a RAID 0. At some point during the night. Down one of the drives, mount it and copy the data. Then unmount it bring it back on-line. The RAID card should re-sync them without any down time.
=C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Philip Mak [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 3:16 AM To: [EMAIL PROTECTED] Subject: How to backup without blocking? sql, query Right now, every day I run the equivalent of a mysqlhotcopy on my database (read-lock the tables, copy the files, unlock the tables). This freezes up everything (websites, etc.) that uses the database for 10 minutes. That is too long. Is there a way to get a snapshot of the database without locking the tables? Do I need to convert from MyISAM to InnoDB perhaps? --------------------------------------------------------------------- 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
