Hi, You can also use mysql replication: you install a slave server and run mysqlhotcopy on it. This way, you never freeze the master server.
Hope this helps Joseph Bueno Philip Mak wrote: > 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
