mysqlbinlog does not filter event for database
Posted by:
Ravi Thati
Date: January 08, 2010 07:00AM
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
Subject
Views
Written By
Posted
mysqlbinlog does not filter event for database
4701
January 08, 2010 07:00AM
2323
January 21, 2010 02:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.