Home > mysql > fix mysql relay log

fix mysql relay log

February 2, 2009 varnit Leave a comment Go to comments
  • SHOW SLAVE STATUS //note relay_master_log_pos and exec_master_log_pos
  • SLAVE STOP
  • CHANGE MASTER TO MASTER_LOG_FILE=[relay_master_log_pos value], MASTER_LOG_POS=[exec_master_log_pos]
  • SLAVE START
Categories: mysql Tags:
  1. No comments yet.
  1. No trackbacks yet.
You must be logged in to post a comment.