DB dump with single transaction

mysqldump [DB Info] [dump option] [dump target] > /path/to/dump/file.sql

If you want to dump with single transaction..

just add one option in [dump option]

That is "--single-transaction" options.

It make the dump process to slow, but it did not lock the table.

So you can insert, update...etc..during the db dump process.