The --single-transaction flag was added to mysqldump command. Without this option, the database becomes unusable for the period of the backup, which is not ideal in a Live environment
The --single-transaction flag will start a transaction before running. Rather than lock the entire database, this will let mysqldump read the database in the current state at the time of the transaction, making for a consistent data dump.
The --single-transaction flag was added to mysqldump command. Without this option, the database becomes unusable for the period of the backup, which is not ideal in a Live environment The --single-transaction flag will start a transaction before running. Rather than lock the entire database, this will let mysqldump read the database in the current state at the time of the transaction, making for a consistent data dump.