On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote:
>
> I just set up a master/slave replication scheme and all is well, but
> through the procedure did get bit on the tail.
>
> After the setup, and after the master and slave mysql servers had
> been started, I got some error messages that pointed to a type in
> the slave's my.cnf file. I shut the slave down, fixed the typo, and
> restarted. Got the same error.
>
> I had a look at the master.info, and noticed it contained old
> information from the previous my.cnf. There were no binary log
> entries in it, so I shut the slave down, deleted the master.info,
> and restarted the slave. This fixed the problem and they're
> replicating fine. (A terrific feature, my thanks to the mysql team
> for that one.)
>
> Question is, is this behaviour by design? Seems to me if you edit
> my.cnf and restart the mysql slave the master.info entries
> corresponding to the my.cnf file should be updated. Thanks for any
> insight.
That's a common problem. Very common. You have to remove the
master.info file, or edit it by hand. :-(
I've called it a bug several times in the past, but it occurs to me
that I may have never told the person who wrote the replication code.
So...
Sasha: Can this be fixed? In my mind it's a bug. One that has bitten
too many people already.
If not, we at least to get it documented here:
http://www.mysql.com/doc/R/e/Replication_Features.html
Thoughts?
Thanks,
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 6 days, processed 88,944,778 queries (148/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
