> If you use `mysqldump --opt ... If you're still on the mysql 4.0 branch, you don't want to be using --opt with mysql dump. It includes --lock-tables, which is incompatible with InnoDB. the 4.1 branch should be fine. see http://bugs.mysql.com/bug.php?id=5538 for more. seph