You need to shutdown mysql, delete the master.info and
relay-log.info files and then start mysql again.
The reason for this is because if the info files are
present then mysql uses them as is and only recreates them
from my.ini or my.cnf if absent.
This should get your replication going again.
of the server
changing, but that isn't the case here, the hostname is the same as always
(should have added that in the first place).
thanks,
Andrew
From: Lightware Software [EMAIL PROTECTED]
Date: Thu, 29 Jan 2004 08:53:48 +0200
To: [EMAIL PROTECTED]
Subject: Re: weird replication problem
Maybe you should check if the ip address resolved for the
master's url is correct ?
Also try using CHANGE MASTER TO
MASTER_HOST='master host name',
MASTER_USER='replication user name',
MASTER_PASSWORD='replication password';
and then START SLAVE; and see what
problem with master.info being created empty
Maybe you should check if the ip address resolved for the
master's url is correct ?
Also try using CHANGE MASTER TO
MASTER_HOST='master host name',
MASTER_USER='replication user name',
MASTER_PASSWORD='replication password';
and then START