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
expire_logs_days=7 and restart the server. Keep log-bin if you have replication or want a certain flavor of backup. my.cnf file changes do not take effect until you restart mysqld. > -Original Message- > From: Elim Qiu [mailto:elim@gmail.com] > Sent: Thursday, August 02, 2012 9:56 AM >

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