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's the default). I'll try reset master ============= Here are some finding that I got =============== (1) What server fail to start, it always says that missing mysql.sock (2) If I comment both 'log-bin=…' and 'binlog_format=…' setting lines in my.cnf, I can actually stop the logging (3) mysql commands PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS BEFORE '2008-04-02 22:46:26'; Worked very well (4) Got to learn how to use those log files and turn the logging on with some sort of controls. Weekly rotate and/or size limit are good ideas Thank you all again