Cannot start replication on slave
Hello all,
I have scoured the internet and forums before posting this, I appreciate the time taken to read this.
I have previously setup a master-slave replication from 0. I am now trying to do it in a working production system.
I lock the masters tables with FLUSH TABLES WITH READ LOCK, and take note of the status with SHOW MASTER STATUS. Before unlocking the tables, I make a full copy of the databases into the slave using mysqldump. I then execute UNLOCK TABLES.
When I get to the slave, and try
RESET SLAVE;
STOP SLAVE;
CHANGE MASTER TO
MASTER_HOST='XXX.XXX.XXX.XXX',
MASTER_USER='XXX',
MASTER_PASSWORD='XXXXXX',
MASTER_LOG_FILE='master-bin.000005 ',
MASTER_LOG_POS=18262972;
I get the following error:
ERROR 29 (HY000): File '/var/lib/mysql/master.info' not found (Errcode: 13)
If I try adding the master.info file by hand, with the following permissions:
-rw-rw---- 1 mysql mysql 0 2009-05-28 02:41 master.info
I get the following error:
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
The MySQL error logs are empty.
What can I do?
Thank you
Subject
Views
Written By
Posted
Cannot start replication on slave
5926
May 27, 2009 06:42PM
2428
May 28, 2009 04:49AM
2617
May 28, 2009 09:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.