MySQL Data Dumper

Is there an option like '--master-data' or '--dump-slave'" in mysqldump?

Asked by 刀尖红叶

 '--master-data' or '--dump-slave' option is very useful while building a new slave,so does it exit an similiar option in mydumper?

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Data Dumper Edit question
Assignee:
No assignee Edit question
Solved by:
刀尖红叶
Solved:
Last query:
Last reply:
Revision history for this message
Max Bubenick (max-bubenick) said : 		#1

you don't need any additional option with mydumper, you will get both coordinates on metadata file

$ cat metadata
Started dump at: 2014-11-12 01:41:46
SHOW MASTER STATUS:
 Log: mysql-bin.001928
 Pos: 120

SHOW SLAVE STATUS:
 Host: 10.10.10.10
 Log: mysql-bin.007169
 Pos: 27198084

Finished dump at: 2014-11-12 05:09:2

Revision history for this message
刀尖红叶 (leafonsword) said : 		#2

Thx~