From: Prabhat Kumar Date: April 19 2010 4:40am Subject: Re: mysql-bin log file List-Archive: http://lists.mysql.com/mysql/221292 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00163630fd5bf623d404848f8d72 --00163630fd5bf623d404848f8d72 Content-Type: text/plain; charset=ISO-8859-1 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 wrote: > On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul > 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 > wultsch@stripped > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=aim.prabhat@stripped > > -- 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 --00163630fd5bf623d404848f8d72--