MySQL Forums
Forum List  »  Replication

Cannot start replication on slave
Posted by: Alex Recarey
Date: May 27, 2009 06:42PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot start replication on slave
5926
May 27, 2009 06:42PM


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.