You can add a *expire_logs_days* Variable in my.cnf during the
configuration of replication server.
#* expire_logs_days = 7*
It will purged binary logs older than 7 days.The old logs will be purged
during the next bin-log switch.
Or, You can also delete bin-log manually using command :
PURGE BINARY LOGS TO 'mysql-bin.010';
PURGE BINARY LOGS BEFORE '2008-04-02 22:46:26';
but before you purge please make sure that slave is on sync with master or
confirm the current status from slaves.
On Mon, Apr 19, 2010 at 9:47 AM, Rob Wultsch <wultsch@stripped> wrote:
> On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul <arshupaul@stripped>
> > How can I remove old mysql-bin log file in log directory? A mysql full
> > backup will clear the old mysql bin log file or not?
> > Thanks,
> > Arshu Paul
> You probably want
> Rob Wultsch
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Mobile : 91-9987681929
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat