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