The mysqldump command is used in MySQL to create backups of databases. The option --master-data[=#] was traditionally used to include the binary log position information in the dump file, although it is now deprecated. This option was particularly useful for ensuring consistency when replicating databases across different MySQL servers.
Here are several examples demonstrating the use of --master-data:
Example 1: Dumping a database with binary log position appended:
mysqldump --master-data=2 -u username -p dbname > backup.sql
Explanation: This command dumps the database dbname while including the binary log position in the output file backup.sql. The =2 specifies the level of binary log information to include (in this case, full binary log position).
Example 2: Using --master-data=1 for minimal binary log position:
mysqldump --master-data=1 -u username -p dbname > backup.sql
Explanation: Here, --master-data=1 includes only minimal binary log position information in the dump file.
Example 3: Dumping with default binary log position:
mysqldump --master-data -u username -p dbname > backup.sql
Explanation: The default behavior of --master-data includes the binary log position without specifying a particular level.
Also check similar articles.
Appending Binary Log Position in mysqldump Output
Setting Long Query Time for mysqldump
Logging Errors to File in mysqldump
Locking Tables for Read in mysqldump
Locking All Tables Across Databases in mysqldump
Discussion about this post