Does replication also replicate table creation ?
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 ?
Subject
Views
Written By
Posted
Does replication also replicate table creation ?
2935
June 03, 2005 09:08AM
1995
August 18, 2005 08:27AM
2048
August 23, 2005 12:19AM
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.