Re: Fixing gaps in replication

Hi,

add the line 'slave-skip-errors = 1062' to your mysql configuration file, reload mysql and tell MySQL to start replicating where things got messud up.

Kind Regards,
Jochen Billen

On Thu, 2007-06-28 at 11:07 +0200, Wayne Gemmell wrote:
> Hi all, is there any way I can get my slave to re-read the master servers
> binary log? I've got about 1000 transactions missing on my slave from when I
> was messing around trying to get replication re-started and I want it to
> re-read that part of the masters log without messing up my circular
> replication with 1062 errors.
>
> Any ideas?
>
> Cheers
> Wayne
>

-- 
Smartbit bvba
Hoogstraat 13
B-3670 Meeuwen, België
t. +32 89 46 81 08
f. +32 89 46 81 10
e. jochen@smartbit.be


-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com