List:Replication« Previous MessageNext Message »
From:Rick James Date:June 10 2009 6:37pm
Subject:RE: How to purge relay-bin file
View as plain text  
Look for the PURGE command.
Check you're my.cnf for 'bin' and 'relay'.
Look at the file relay*x -- one of them should have a list of current
relay log(s).  Any relay logs older than that can be simpled rm'd.

(If you are running Windows, some of the above needs transliterating.)

 
Rick James
MySQL Geeks - Consulting & Review

 

> -----Original Message-----
> From: Database System [mailto:database100@stripped] 
> Sent: Wednesday, June 03, 2009 6:08 AM
> To: replication@stripped
> Subject: How to purge relay-bin file
> 
> 
> Hi,
> 
> There are many relay files on master server, don't know why. 
> There is no setup for that in my.ini file. If I just simply 
> delete those files, it won't match the content of relay-index 
> file. How to purge those? 
> 
> If I simply delete all relay files and relay-index file, when 
> I need this server as slave (one of master to master), can I 
> just use change master to command, then will all relay files 
> and relay index automatically generated again?
> 
> Thanks,
> Lisa 
> 
> 
>       
> 
> -- 
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    
> http://lists.mysql.com/replication?unsub=1
> 
> 
Thread
How to purge relay-bin fileDatabase System3 Jun
  • RE: How to purge relay-bin fileRick James10 Jun
RE: How to purge relay-bin fileDatabase System10 Jun
  • Re: How to purge relay-bin fileAndrew Garner11 Jun