SQL
> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> >
> > Sorry. I am wrong. Situation is worse.
> > Both tables aren't replicate to the slave.
> > But query try run it on slave :(
> >
> > slave: mysql-4.0.13
> > master: mysql-4.0.14
>
> What replication options do you use?
Full scheme is:
<----|
+-A| C
| ----->|
|
+->B
Configuration A:
server-id = 4
master-host=XXX
master-user=XXX
master-password=XXX
master-port=3306
replicate-do-db=ZZ
master-connect-retry=60
log-slave-updates
=====================
Configuration B:
server-id = 3
user = mysql
master-host = 195.248.191.22
master-user = ghsdr_repl
master-password = Dtp6TrH
master-port = 3306
replicate-do-db = ZZ
replicate-do-table = ZZ.counter
replicate-do-table = ZZ.counter_price
replicate-do-table = ZZ.reserv_unit
replicate-do-table = ZZ.service
replicate-do-table = ZZ.ppp_utmp
replicate-do-table = ZZ.net
replicate-do-table = ZZ.service_net
But there are no tables A and B in replicate-do-table list.
>
> >
> >>
> >> 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;
> >>
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Egor Egorov
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
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]
