1RESET MASTER;
2CREATE DATABASE db1;
3USE db1;
4CREATE TABLE t1 (i INT);
5INSERT INTO t1 VALUES(1);
6INSERT INTO t1 VALUES(2);
7UPDATE t1 SET i= i+1;
8DELETE FROM t1 WHERE i=2;
9[The use <db_name> is not suppressed in the general use of mysqlbinlog]
10Matching lines are:
11use `db1`/*!*/;
12
13Occurrences of the use `db1` in the input file : 1
14[The use <db_name> is suppressed on using rewrite-db option of mysqlbinlog]
15Matching lines are:
16None
17Occurrences of the use `db1` in the input file : 0
18CREATE DATABASE db2;
19DROP DATABASE db1;
20RESET MASTER;
21SELECT * FROM db2.t1;
22ERROR 42S02: Table 'db2.t1' doesn't exist
23DROP DATABASE db1;
24RESET MASTER;
25[The event of table db1.t1 has been successfully applied to db2.t1]
26include/assert.inc [Assert that table db2.t1 has no rows after applying the sql file.]
27[CLEANUP]
28DROP DATABASE db1;
29DROP DATABASE db2;
30