MySQL Forums
Forum List  »  Replication

Cannot Start Replication on Slave - "cannot find master.info"
Posted by: Alex Recarey
Date: May 27, 2009 06:26PM

Hello everybody.

I have scoured the forums and the web searching to an answer to my problem to no avail. Thank you for taking the time to read about it.

I am using mysql 5.0.32 on Debian etch.

I have one server set up as MySQL replication master, with binlog properly configured and working.

I have another setup for use as a slave. The slave has a snapshot taken from the master while the master was "FLUSH TABLES WITH READ LOCK". I have noted the bil log file and position using the SHOW MASTER STATUS command.

I switch to the slave, login, and execute:

RESET SLAVE
STOP SLAVE

CHANGE MASTER TO
MASTER_HOST='XXX.XXX.XXX.XXX',
MASTER_USER='xxxxx',
MASTER_PASSWORD='xxxxxxx',
MASTER_LOG_FILE='master-bin.000005 ',
MASTER_LOG_POS=18262972;

I receive:

ERROR 29 (HY000): File '/var/lib/mysql/master.info' not found (Errcode: 13)

Yes, the master's binlog file is named master-bin.000005


If i manually create a master.info file, and change the permissions so that they are:

-rw-rw---- 1 mysql mysql 0 2009-05-28 02:19 master.info


When I put the command RESET SLAVE I get the message:
ERROR 6 (HY000): Error on delete of '/var/lib/mysql/master.info' (Errcode: 13)


If I directly try the CHANGE MASTER TO command:
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

and the mysql error log shows nothing.

I have read the manual countless times, and I have also set up a replication setup successfully between two virtual machines. What am I doing wrong?

Thank you for your help.

Alex

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot Start Replication on Slave - "cannot find master.info"
11660
May 27, 2009 06:26PM


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.