Group items tagged

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: