Nov 18
If you replication slave reboots and you get error messages like:
ERROR 1201: Could not initialize master info structure, more error messages can be found in the MySQL error log
Fix i found for it was manually adding the master.info back to slave:
STOP SLAVE RESET SLAVE CHANGE MASTER TO MASTER_HOST=’your_master’, MASTER_USER=’your_login’, MASTER_PASSWORD=’your_password’, MASTER_LOG_FILE=’log_file’, MASTER_LOG_POS=log_position START SLAVE
If you get errors, try:
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1 START SLAVE
Source: http://blog.bit-matrix.com/2008/11/19/mysql-replication-error-1201-could-not-initialize-master-info-structure/
Leave a Reply
You must be logged in to post a comment.