Re: weird replication problem with master.info being created empty

2004-01-29 Thread Andrew
D]> > Date: Thu, 29 Jan 2004 10:25:24 +0200 > To: [EMAIL PROTECTED] > Subject: Re: weird replication 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 MA

Re: weird replication problem with master.info being created empty

2004-01-29 Thread Lightware Software
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_USER='', MASTER_PASSWORD=''; and then START SLAVE; and see what happens. regards Jurgen > Tried that, but no luck, they get r

Re: weird replication problem with master.info being created empty

2004-01-29 Thread Andrew
f 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] > Subje

Re: weird replication problem with master.info being created empty

2004-01-29 Thread Lightware Software
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. re

weird replication problem with master.info being created empty

2004-01-28 Thread Andrew
Hi all, Have a problem, running a master/slave setup which worked until tonight and mysteriously broke with no changes to the setup at all. My server starts up fine, but the master.info and relay-log.info that are created are 0 bytes and empty. In the logfile, I get this: 040128 23:00:29 Error r