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 happens.
regards Jurgen
> 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).
>
>
> >
> > 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]
