List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:April 19 2010 4:40am
Subject:Re: mysql-bin log file
View as plain text  
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 <wultsch@stripped> wrote:

> On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul <arshupaul@stripped>
> 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=1
>
>


-- 
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

Thread
mysql-bin log fileAngelina Paul19 Apr
  • Re: mysql-bin log fileRob Wultsch19 Apr
    • Re: mysql-bin log filePrabhat Kumar19 Apr
      • Re: mysql-bin log fileRob Wultsch19 Apr
        • Re: mysql-bin log fileJohan De Meersman19 Apr
          • Re: mysql-bin log fileRob Wultsch19 Apr
            • Re: mysql-bin log fileJohan De Meersman19 Apr