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.
Yes, I was wrong.
Further manual readings needed. The database involved in binary log is the
one selected by USE.
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.
Yes, I trusted the warning in the config files, but checked out my "my.cnf"
and directives are the same.
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?
Maybe he could stop doing binary logs, start and stop mysql, clean the
/var/log/mysql, restart the server and see if it still complains about
/var/log/mysql/mysql-bin.index missing or if he gets a permission denied for
mysql attempting to create it.
Cheers,
Andy
regards
raffaele
