Use this option to dump a master replication server to produce a dump file that can be used to set up another server as a slave of the master. It causes the dump output to
include a CHANGE MASTER TO statement that indicates the binary log coordinates (file name and position) of the dumped server. These are the master server coordinates from which
the slave should start replicating.
If the option value is 2, the CHANGE MASTER TO statement is written as an SQL comment, and thus is informative only; it has no effect when the dump file is reloaded. If the
option value is 1, the statement takes effect when the dump file is reloaded. If the option value is not specified, the default value is 1.
mysqldump导出数据时,当这个参数的值为1的时候,mysqldump出来的文件就会包括CHANGE MASTER TO这个语句,CHANGE MASTER TO后面紧接着就是file和position的记录,在slave上导入数据时就会执
行这个语句,salve就会根据指定这个文件位置从master端复制binlog。默认情况下这个值是1
当这个值是2的时候,chang master to也是会写到dump文件里面去的
mysql --master-data 参数
最新推荐文章于 2024-04-23 11:31:48 发布
本文介绍了在使用mysqldump时`--master-data`参数的作用,它用于创建从属服务器的备份文件,包含CHANGE MASTER TO语句,指定了主服务器的二进制日志坐标。当值为1时,该语句在导入时生效,为2时则作为注释。文章还演示了如何使用此参数进行数据导出,并展示了如何编辑和应用CHANGE MASTER TO语句来设置复制。
摘要由CSDN通过智能技术生成