On Mon, Aug 13, 2001 at 05:23:44AM +0200, Steve Rapaport wrote:
>
> Has anyone successfully resynchronized two replicated Mysql's (most
> recent version)?
>
> I had a big glitch so I followed the directions in the manual: shut
> down the servers, checked the my.cfg settings, copied over the whole
> data directory, and restarted both servers.
>
> I keep getting an error message in the log that says one of my
> databases can't be created because it already exists! (I know it
> exists, why are you trying to create it??!!).
>
> Anyway, more details to anyone who volunteers to help...
The problem is that the binary log on your master is "older" than the
data on the slave. You need to reset the binary log on the master if
you want to use that approach.
The `myrepl' script I posted here several months back automates the
task. You might want to check the archives.
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.29: up 59 days, processed 529,125,983 queries (102/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
