MySQL Forums
Forum List  »  Replication

Does replication also replicate table creation ?
Posted by: Danny Sinang
Date: June 03, 2005 09:08AM

Dear All,

Am quite new to replication, so please bear with me. Here's our replication setup :

Master : MySQL 4.0.16-max-log
Slave : MySQL 4.1.10a-max-log

Replication has been going well for the past few weeks until an InnoDB table was created on the Master which caused replication to stop with the following error :

=======================

Error 'Table 'dbBarmain.tblDadmainUsers' doesn't exist' on query.
Default database: 'dbBarmain'. Query: 'update `dbBarmain`.`tblDadmainUsers`
set `UserId`='1', `Username`='ZZ57', `Password`='zipzag', `Fullname`=NULL, `Project`='myProject'
where `UserId`='1' and `Username`='ZZ57''

=======================

My question is, does MySQL support replication of CREATE TABLE statements ? If so, how do I enable it ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Does replication also replicate table creation ?
2935
June 03, 2005 09:08AM


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.