Nov 28
Could not initialize master info structure, more error messages can be found in the MySQL error log
MySQL Add comments
994
I have one master and about 2 slave servers. Time to time one (absolutely random) slave server lost replication connection. When i type slave stop; slave start; i see “ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log”
Last i solved the problem by issuing the following commands
Login to mysql, then perform these steps:
1.)mysql> reset slave;
2.)mysql> start slave;
Tags:connection, error messages, logins, logs, mysql, mysql error, replication, servers, slave server, stop, type slave
Liked this article? To continue getting our latest free Howtos and Tutorials,
you can also grab the RSS feed or Subscribe to Techgurulive by Email
you can also grab the RSS feed or Subscribe to Techgurulive by Email
Not Getting
Related postsHow to view Master status in Mysql Replication
How to monitor your Mysql slave Replication status
