Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've been tasked with assorted maintenance of a DB. I have very little experience with MySQL, so pardon any ignorance :)

Two (well, four) related questions:

  1. The DB is supposed to be replicated to a backup slave, but it's been pointing at the wrong host for quite some time, so it's currently months behind. It looks like I want to run change master to from the slave to fix this.
    • Is it generally safe to do this live?
    • If not, is there a static config counterpart to the command, such that I can send it out in a managed deployment?
  2. We suspect the binary logs on the master may be corrupt/incomplete.
    • Will this affect the ability to fully replicate all data?
    • If so, how can I ensure a full backup? Is a full mysqldump overnight avoidable?

Hopefully I'm not barking up the wrong tree here. Feel free to point me in a different direction. The overall need is to have a backup, of some sort, as soon as possible. Thanks!

share|improve this question

migrated from Oct 17 '13 at 10:50

This question came from our site for computer enthusiasts and power users.

Sounds like a overnight backup is in order to get a baseline backup state is in order you can then address the log problem and start backing it up nightly there affer – Ramhound Oct 17 '13 at 0:24 may be a better place to ask this.

share|improve this answer
Ack, you're right. I'm always confusing these two in my head. Any friendly mods care to migrate? I don't believe I can do so myself. – Cheezmeister Oct 17 '13 at 1:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.