MySQL Forums
Forum List  »  Data Recovery

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlbinlog does not filter event for database
4507
January 08, 2010 07:00AM


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.