Row based format-opracowanie

Row based format. Tells the server not to log updates to any tables in the database db_name.
The current database has no effect.
When using statement-based logging, the following example does not work as you might expect.
Suppose that the server is started with --binlog-ignore-db=sales [2043] and you issue the
following statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
The UPDATE statement is logged in such a case because --binlog-ignore-db [2043] applies
only to the default database (determined by the USE statement). Because the sales database
was specified explicitly in the statement, the statement has not been filtered. However, when using
row-based logging, the UPDATE statement's effects are not written to the binary log, which means
that no changes to the sales.january table are logged; in this instance, --binlog-ignoredb=
sales [2043] causes all changes made to tables in the master's copy of the sales database to
be ignored for purposes of binary logging.
To specify more than one database to ignore, use this option multiple times, once for each database.
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.
... zobacz całą notatkę