You can choose which databases should be written to the binary log by specifying the --binlog-do-db=db_name
option in my.cnf
. To specify multiple databases you must use multiple instances of this option. Because database names can contain commas, the list will be treated as the name of a single database if you supply a comma-separated list. You need to restart the MySQL server to effect changes.
Open my.cnf
and add the following lines:
shell> sudo vi /etc/my.cnf [mysqld] binlog_do_db=db1 binlog_do_db=db2
The behavior on binlog-do-db
changes from statement-based logging to row-based logging just like the --database
option in the mysqlbinlog
utility.
In statement-based logging, only those statements are written to the binary log where the default database (that is, the one selected by USE
) is written to the binary log. You should be very careful while using the binlog-do-db
option because it does not work as you might expect when using...