MySQL Forums
Forum List  »  Replication

Replication Problem
Posted by: Michelangelo Rezzonico
Date: February 24, 2005 08:14AM

Hi all,

I have a *big* problem and before solving this problem I cannot go productive with my application. Pleas help me to find a workaround.

I have two host (A and B).
I have setup a replication (from A to B).
binlog-do-db=db1 (only db1 will be replicated from A to B).

Consider the following example:

1) On host A:
mysql
use test;
create database db2; (db2 is created only on host A)
quit

2) On host A:
mysql
drop database db2; (this command is replicated on host B)

After step 2 the replication stop.
On host B the command "show slave status" report the following error:

Last_error: Error 'Can't drop database 'db2'. Database doesn't exist' on query 'drop database db2'. Default database: ''

The problem is that if I log into host A, all the command executed before the command "use" are replicated to host B.

Best regards. Michelangelo

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication Problem
3141
February 24, 2005 08:14AM


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.