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
