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. Thanks, On Mon, Apr 19, 2010 at 9:47 AM, Rob Wultsch <wult...@gmail.com> wrote: > On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul <arshup...@gmail.com> > wrote: > > 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 > http://mysql2.mirrors-r-us.net/doc/refman/5.1/en/purge-master-logs.html > > > -- > Rob Wultsch > wult...@gmail.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com > > -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
