Magento Dump without block
"Statements and Performance"

Before

mysqldump -h'hostname' -u'username' -p'password' 'livedbname'

• Dump time: ~6 Min.
• Website blocked

After

mysqldump -h'hostname' -u'username' -p'password' --single-transaction --quick 'livedbname'

• Dump time: 3 Min.
• Website not blocked!

Links:

• http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_compact
• http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction
• http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_quick"

Quelle: https://gist.github.com/avoelkl/49563c516d6cb318eb34