mysql --master-data 参数

最新推荐文章于 2021-01-27 20:21:03 发布

scan724

最新推荐文章于 2021-01-27 20:21:03 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： Mysql

本文链接：https://blog.youkuaiyun.com/zhaoyangjian724/article/details/46366715

Mysql 专栏收录该内容

90 篇文章 ¥39.90 ¥99.00

订阅专栏

本文介绍了在使用mysqldump时`--master-data`参数的作用，它用于创建从属服务器的备份文件，包含CHANGE MASTER TO语句，指定了主服务器的二进制日志坐标。当值为1时，该语句在导入时生效，为2时则作为注释。文章还演示了如何使用此参数进行数据导出，并展示了如何编辑和应用CHANGE MASTER TO语句来设置复制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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这

了解本专栏