Hi, All!
SQL, mysql

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

>
> 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]
>
>

    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]

  • ... ΝΙΚΟΣ ΓΑΤΣΗΣ
  • ... unplug
  • ... Rudy Metzger
  • ... ΝΙΚΟΣ ΓΑΤΣΗΣ
  • ... Jeff McKeon
  • ... Jeff McKeon
    • ... Dathan Vance Pattishall
  • ... Dathan Vance Pattishall
  • ... Andrey Kotrekhov
    • ... colbey
    • ... Andrey Kotrekhov
      • ... Egor Egorov
        • ... Andrey Kotrekhov
  • ... Luciano Barcaro
  • ... Andrew Hall
  • ... Victor Pendleton
    • ... Andrew Hall
  • ... Jeff McKeon
    • ... Tobias Asplund
  • ... Jeff McKeon
  • ... Jonas Lindén

Reply via email to