On Sun, Feb 11, 2007 at 09:51:35AM -0800, tom arnall wrote: > On Sunday 11 February 2007 02:12, Raffaele Morelli wrote: > > Hi, > > > > quoting from your my.cnf > > > > # WARNING: Using expire_logs_days without bin_log crashes the server! See > > README.Debian! > > expire_logs_days = 10 > > max_binlog_size = 100M > > #binlog_do_db = include_database_name > > #binlog_ignore_db = include_database_name > > > > you are using a 10 days expire logs directive without uncomment the > > 'binlog_do_db' directive and without indicating a database name for it, no > > matter the 'WARNING: Using expire_logs_days without bin_log crashes the > > server!" says about.
Raffaele, if you do not set binlog_do_db and binlog_ignore_db then all databases are logged. > > Try not to use binary logs or set parameters correctly for them. I believe the set parameters are correct if he wishes to log all databases to binary log. > how did you get this information? are there any books that cover this kind of > thing? Tom, The warning is in the config file itself. However I do not believe that Raffaele's advice is correct; you ARE doing binary logging; you have bin_log set and there are clearly binary logs in your /var/log/mysql directory. The parameter that Raffaele speaks of, binlog_do_db, does not enable/disable binary logging. bin_log does that. You are safe to leave binlog_do_db and binlog_ignore_db commented if you intend to log all or nothing. How did it go with the changing ownership of files that I recommended? Cheers, Andy -- http://bitfolk.com/ -- No-nonsense VPS hosting Encrypted mail welcome - keyid 0x604DE5DB
signature.asc
Description: Digital signature