mysqlbinlog does not filter event for database

[Ravi Thati]

Hi All,

i have created the table like
create table db.table(i int);
insert into db.table(i) values(0);
and so on..

these have been taken backup(manual copy of logs and dump of dbs)

When doing the restore, i am doing mysqlbinlog on each log.

let us assume i have above statments in mysql_bin.00001 file.
then,
mysqlbinlog -s -d db mysql_bin.00001 ; does not give me the above events.


Is there something wrong in creating and referring table with db.table format??

Does mysqlbinlog cable of filter such events when doing filter by database name??

if it is , is there a flag for that??



thanks in advance,
Ravi Thati