Skip to main content
Eborbob's user avatar
Eborbob's user avatar
Eborbob's user avatar
Eborbob
  • Member for 8 years, 4 months
  • Last seen more than 2 years ago
  • UK
awarded
awarded
awarded
comment
Possible to get equivalent MySQL bin log position on another server?
That's true. I wasn't quite telling the truth in the question - I didn't run show master status at all, I performed a mysqldump with the --single-transaction --master-data=2 parameters.
awarded
comment
Possible to get equivalent MySQL bin log position on another server?
Thanks, that is indeed the way to do it before you make a dump - in my situation though I'd already got the dump and log position on the slave and needed to convert that into the master log position.
awarded
Loading…
awarded
Loading…
awarded
comment
The table mysql.proc is missing, corrupt, or contains bad data
Thanks for the suggestion. I've run show create table mysql.proc on a working and non-working server (same MySQL version) and the result is identical on both.
awarded
Loading…