will not speed the process, but it will allow the live application to use the mysql database as normal without locking any tables and preventing the application to change the database.
The --master-data option above locks all
of the tables during the dump to prevent data from being changed, but
allows users to continue reading the tables. With exclusive access,
this feature isn't necessary. However, this option also adds a few
lines like the following to the end of the dump file: