List:General Discussion« Previous MessageNext Message »
From:Vikas Shukla Date:August 2 2012 6:49pm
Subject:Re: manage mysql-bin.xxxxxx files on mac
View as plain text  
Hi ,,

It would be helpful if you could share the error messages.

Do any of these:

1) Add these lines to my.cnf file:
      expire_logs_days = 7
2) Or Try this
      log-bin=OFF
             or simply u can comment the lines related to the log-bin.

3) Other than this,
        if you are using server-id=1 in the my.cnf file,
         Try running RESET MASTER in the mysql prompt.

Hope it woks
Do share the error message if possible.
Thanks.
On Thu, Aug 2, 2012 at 10:37 PM, Rik Wasmus <rik@stripped> wrote:

> Hm, due to some popups that was a premature sending... Mea culpa
>
> > > I don't really know how to use those files and so like to know how to
> > > stop populating them. or at least control the number and size of them.
> >
> > Used for: disaster recovery / replay modifications on backup, or
> > replication afaik.
> >
> > Days kept: expire_log_days:
> >
> > http://dev.mysql.com/doc/refman/5.5/en/server-system-
> > variables.html#sysvar_expire_logs_days
> >
> > Max size: max_binlog_size:
>
> http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-
> log.html#sysvar_max_binlog_size
>
> (this is per file)
>
> > > I'm running os x 10.6.8, mysql Server version: 5.1.61-log MySQL
> > > Community Server (GPL)
> > >
> > > I tried comment out the line "log-bin=mysql-bin" and those
> > > mysql-bin.xxxxxx files in the data directory. It causes mysql server
> > > starting failure.
>
> Don't just delete the bin-files. First start with log-bin=off (or no
> log-bin
> declaration). If that fails to start your server, show us the actual error.
>  --
> Rik Wasmus
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
manage mysql-bin.xxxxxx files on macElim Qiu2 Aug
  • Re: manage mysql-bin.xxxxxx files on macRik Wasmus2 Aug
    • Re: manage mysql-bin.xxxxxx files on macRik Wasmus2 Aug
      • Re: manage mysql-bin.xxxxxx files on macVikas Shukla2 Aug
        • Re: manage mysql-bin.xxxxxx files on macElim Qiu2 Aug
          • Re: manage mysql-bin.xxxxxx files on macRik Wasmus3 Aug
  • RE: manage mysql-bin.xxxxxx files on macRick James2 Aug