Tuesday, January 24, 2012

ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

For resolving the problems follow below steps:

1.       Stop & Reset slave

mysql> stop slave;
mysql> reset slave;

2.       Change log position & master log file name

mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.0000xx', MASTER_LOG_POS=xxxx;

3.       Start slave

mysql> start slave;

4.       Check slave status

mysql> show slave status\G;

Output include below output:

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

No comments:

Post a Comment