I'm pretty sure you need to sync the entire database (all tables) to all slaves before starting replication.. Your servers are technically already out of sync..
And no wonder it crashes, tables are missing in it's view.. You need to hit the initial replication setup manual pages.. On Thu, 18 Sep 2003, Andrey Kotrekhov wrote: > Hi, All! > SQL, mysql > > I have 2 servers. 1-st is master, 2-d - slave. > But slave store only some tables of master. > For example, master has tables A, B > But slave has only A table > > The problem: > > query: UPDATE A,B SET A.a=B.a WHERE A.c=B.c; > the result: crash replication on slave; > > Is it right? > > > Best regards. > _______________________________________ > Andrey Kotrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > тел. +380 562 34-00-44 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
