Re: Re; Re: question for replication

2004-02-12 Thread Liying Huang
still. :<. Liying - Original Message - From: <[EMAIL PROTECTED]> To: "Liying Huang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 11:00 AM Subject: Re: Re; Re: question for replication Was the update peformed in eit

Re: Re; Re: question for replication

2004-02-12 Thread Liying Huang
Subject: Re: Re; Re: question for replication Was the update peformed in either the WITCD or WITTD database? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/12/04, 9:52:57 AM, Liy

Re: Re; Re: question for replication

2004-02-12 Thread Liying Huang
I just use "update *** set ***" query on WITCD, Victoria might find out the problem for me, I didn't specify database in query, if database is not current, the query will not be updated. I am trying to use one database to be current for both master and slave, and see if query will update slave or

Re: Re; Re: question for replication

2004-02-12 Thread vpendleton
Was the update peformed in either the WITCD or WITTD database? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/12/04, 9:52:57 AM, Liying Huang <[EMAIL PROTECTED]>

Re; Re: question for replication

2004-02-12 Thread Liying Huang
Show slave status: *** 1. row *** Master_Host: lhuang Master_User: test Master_Port: 3306 Connect_retry: 60 Master_Log_File: lhuang-bin.001 Read_Master_Log_Pos: 79 Relay_Log_File: liyingtop-relay-