Tried that, but no luck, they get recreated, but they still have 0 bytes in them. This is really driving me crazy because although it's come up before on lists, noone has ever really had an answer for it that makes sense. The url I mentioned earlier does say something about the hostname 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 with master.info being created empty > > 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. > regards Jurgen > >> 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 reading slave log configuration >> 040128 23:00:29 Failed to initialize the master info >> structure >> >> and when I run "slave start" >> >> I get this: >> >> ERROR 1201: Could not initialize master info structure, >> check permisions on >> master.info >> >> The blank files in question have okay permissions >> (mysql:mysql) as does the >> directory they're in, and they ARE getting written to, >> just nothing is being >> written. The my.cnf file also has appropriate permissions >> and is readable by >> mysql (so it's not a case of the server not knowing what >> to write in those >> files). Moreover, nothing has changed on the server >> config at all. I've >> tried resetting the master and slave but it doesn't help. >> >> I was running version 4.0.12-0 but just upgraded to >> 4.0.17-0 which hasn't >> helped at all, and the only thing I can find in the >> archives are similar >> problems with the same error number that either turn out >> to be legit >> permissions errors (which isn't the case here), and this: >> http://lists.mysql.com/bugs/15135 which I don't really >> follow as far as what >> the final solution was. >> > __________________________________________________________________________ > http://www.webmail.co.za/dialup Webmail ISP - Cool Connection, Cool Price > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
