Re: mysqldump with --single-transaction backup still blocks the write

[ray somcio]

Hi Lisa,

I'm not sure which version you are running but i think the problem is by default the --opt options is on. This option locks the database unless you explicitly say --skip-lock-tables.

mysqldump -proot -pxxx --skip-lock-tables --single-transaction database

=== from the manual ===

--opt

This option is shorthand; it is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. It should give you a fast dump operation and produce a dump file that can be reloaded into a MySQL server quickly.

As of MySQL 4.1, --opt is enabled by default, but can be disabled with --skip-opt. To disable only certain of the options enabled by --opt, use their --skip forms; for example, --skip-add-drop-table or --skip-quick.