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