On Mon, 2007-08-27 at 16:54 +1000, William Hausler wrote: > Hi All, > > Is there any way to alter an RPM installed version of Bacula (2.0.1) so > that Binary Logging can be turned off in a MySQL database during Catalog > updates (by issuing the "SET SQL_LOG_BIN=0;" as the first SQL statement > after a new database connection)? >
You could alter your mysql my.cnf file to turn off binary logging for your bacula database. That would stop logging for all of the bacula database but if you turn off logging for parts the rest becomes pretty much useless anyway. Just add binlog-ignore-db = bacula (replace bacula with the name of your bacula database) into my.cnf and then restart mysql. > The machine which has the Bacula MySQL database on it also houses a > number of other system databases which are accessed at different times > of the day/night and require Binary Logging enabled. But the Bacula > catalog does not need this, and currently the binary logs grow by ~1.5Gb > each night when Bacula runs. > > Thanks in advance for any tips/suggestions. -- Richard Mortimer <[EMAIL PROTECTED]> ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
