I have a database-driven web site that uses PHP and MySQL 3.23.38. The database is about 1 gigabyte in size. While performing a mysqldump --opt to back up the database, the web site is completely inaccessible. After doing some investigating, I believe that this is because of the --lock-tables option that is implied by the --opt argument. Every page of the web site updates a session table that is a heap table. It looks like the mysqlpdump is locking the heap table for read along with all of the other tables while the dump is occuring. Should heap tables really be locked during the mysqldump? Does anyone have any ideas for a way to back up the database without having the site be down while it happens? Cory. --------------------------------------------------------------------- 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
