Error: "could not initailize master info structure" while doing Master Slave Replication in MySQL

mysql replication master slave
user619684 picture user619684 · Feb 17, 2011 · Viewed 54k times · Source

I am trying to do Master Slave Replication for MySQL. When i am typing the following command:

CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228;
mysql> START SLAVE;

it throws the following error:

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

Any help would be greatly appreciated.

Answer

Neo picture Neo · Mar 29, 2012

TRY TO RESET IT, IT DOES MAGIC! ON SLAVE THE SLAVE MYSQL COMMAND TYPE:

RESET SLAVE;

THEN TRY AGAIN:

CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228;
mysql> START SLAVE;

Related questions

mysql replication - slave server on one database

I couldn't find an answer to my question. I have 2 mysql servers. Master server Slave server Now i want to add another Slave server but i have other website running on that server. Can i replicate just one database?

Read More
MySQL Master-Slave-Slave Configuration

Quick questions about MySQL Master-Slave-Slave set-ups: I currently have a Master-Slave set up right now and I would like to add another slave. Would it be possible to clone the server running the slave, and then spin up a new …

Read More
MySQL in star topology

I have one central database with all the data in MySQL 5.1-lastest-stable. I want to hook up multiple clients in a master-master relationship. Question How do I setup a star topology with 1 central server in the middle with multiple client-databases …

Read More