Search Results
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 |
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 …
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 …