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]
