Re: manage mysql-bin.xxxxxx files on mac

2012-08-03 Thread Rik Wasmus
> (1) What server fail to start, it always says that missing mysql.sock I seem to remember some distro's switching over from mysql.sock so mysqld.sock... is that mysqld.sock there after restart? If so, just update your "socket" configuration accordingly / make it consistent. -- Rik Wasmus --

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Elim Qiu
Thanks a lot to all helped me out. Really appreciated. Rik Wasmus, Thanks for the Binary Log Documentation http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html#sysvar_max_binlog_size Rick James, I'll try this: expire_logs_days=7 Vikas Shukla, My server-id is 1 (thought that

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Vikas Shukla
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 se

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rik Wasmus
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

RE: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rick James
2 9:56 AM > To: mysql@lists.mysql.com > Subject: manage mysql-bin.xxxxxx files on mac > > 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. > > I'm running os x 10.6.8

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rik Wasmus
> 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

manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Elim Qiu
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. 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.