Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 101365

MySQL version 5.5 - please also tag with mysql for search purposes.

1 vote
2 answers
2k views

Possible to get equivalent MySQL bin log position on another server?

Let's say we have three MySQL servers, mysql1, mysql2 and mysql3. Replication is set up such that mysql3 is the slave of mysql2, and mysql2 is the slave of mysql1. At some point I take a dump of mysq …
Eborbob's user avatar
  • 151
2 votes
Accepted

Possible to get equivalent MySQL bin log position on another server?

I managed to do this by examining the log files using mysqlbinlog. Given the following master log position on mysql2: Master log file = mysql-bin.003151 Master log pos = 46678888 I opened the log …
Eborbob's user avatar
  • 151