On Sunday 11 February 2007 21:57, Andy Smith wrote: > 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
still no luck. to wit: debian:/var/log# chown -Rc mysql:adm /var/log/mysql debian:/var/log# /etc/init.d/mysql start Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! debian:/var/log# tail /var/log/daemon.log Feb 25 13:25:37 localhost mysqld[6044]: 070225 13:25:37 InnoDB: Starting shutdown... Feb 25 13:25:39 localhost mysqld[6044]: 070225 13:25:39 InnoDB: Shutdown completed; log sequence number 0 43665 Feb 25 13:25:39 localhost mysqld[6044]: 070225 13:25:39 [Note] /usr/sbin/mysqld: Shutdown complete Feb 25 13:25:39 localhost mysqld[6044]: Feb 25 13:25:39 localhost mysqld_safe[6073]: ended Feb 25 13:25:51 localhost /etc/init.d/mysql[6191]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Feb 25 13:25:51 localhost /etc/init.d/mysql[6191]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Feb 25 13:25:51 localhost /etc/init.d/mysql[6191]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Feb 25 13:25:51 localhost /etc/init.d/mysql[6191]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Feb 25 13:25:51 localhost /etc/init.d/mysql[6191]: debian:/var/log# and if do mysqld i get: debian:/var/log/mysql# mysqld 070225 13:29:43 InnoDB: Started; log sequence number 0 43665 mysqld: File 'mysql-bin.000658' not found (Errcode: 2) 070225 13:29:43 [ERROR] Failed to open log (file 'mysql-bin.000658', errno 2) 070225 13:29:43 [ERROR] Could not open log file 070225 13:29:43 [ERROR] Can't init tc log 070225 13:29:43 [ERROR] Aborting 070225 13:29:43 InnoDB: Starting shutdown... 070225 13:29:45 InnoDB: Shutdown completed; log sequence number 0 43665 070225 13:29:45 [Note] mysqld: Shutdown complete BUT debian:/var/log/mysql# ls -l /var/log/mysql/*658 -rwxrwxrwx 1 mysql adm 13823 2007-02-04 23:01 /var/log/mysql/mysql-bin.000658 debian:/var/log/mysql# tom -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
