MySQL Forums
Forum List  »  Replication

DROP DATABASE propagation
Posted by: Elvis Cartaya
Date: May 19, 2005 09:17AM

Hi,
I am using mysql replication and I have found some troubles. I am using mysql 3.23.58 in both, slave and master.
First when I create a user in the master, it doesn't propagate to the slave. Second when I use "drop database" sentence in the master, it works but not propagate to the slave. Therefore when I try to create de database again the slave stops and show an error.
I don't know if this is a restriction of the mysql replication or if I am doing something wrong.
I will appreciate any help you can give me.
Regards,

Master my.cnf:
skip-innodb
server-id=1
log-bin
binlog-do-db=allied
binlog-do-db=mysql

Slave my.cnf:
log-bin
server-id=2
slave-skip-errors=all
log-slave-updates
master-host=***
master-user=***
master-password=***
binlog-do-db=allied
replicate-wild-do-table=allied.%
replicate-wild-do-table=mysql.%

--
Elvis Cartaya

Options: ReplyQuote


Subject
Views
Written By
Posted
DROP DATABASE propagation
3771
May 19, 2005 09:17AM


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.