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
It only update WITCD. I finish the switching, query still doesn't update in slave. Liying - Original Message - From: <[EMAIL PROTECTED]> To: "Liying Huang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 11:00 AM

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-

Re: Re: Question about group by or distinct

2002-07-27 Thread Benjamin Pflugmann
Hi. On Fri 2002-07-26 at 11:00:31 -0400, [EMAIL PROTECTED] wrote: > > > >Hi Benjamin, Arjen > > > >I did some testing again. I have 75,000,000 rows table, after using group > >by I got 62,300,000 rows. > >If I use *nix -u sort, I got 74800,00 rows. > > > >I compared the two results, I feel I tru

Re: Re: question

2002-04-25 Thread Victoria Reznichenko
Andrew, Wednesday, April 24, 2002, 9:13:40 PM, you wrote: AC> Basically these two servers are not connected to each other. Look at the secon part of Jason's statement: mysql -h -u -p It means that you connect to another MySQL server ... AC> Also I am using win2k. I believe the syntax tha

Re: Re: Question about left join.

2001-10-24 Thread Matthias Ragaz
This is the second time out of three that I get "filtered out". Couldn't this filter be made a little bit smarter? At 10:00 24.10.2001, you wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of

Re: Re : Question???

2001-02-21 Thread Thiru
I havent done any FoxPro pgmming but if u could you get the error message returned from Mysql.. It sounds like user privilege problem... Cheers! Thiru On Thu, 22 Feb 2001 11:15:23 +0800 "edith" <[EMAIL PROTECTED]> wrote: -> Dear Sir/Madam, -> I'm a Visual FoxPro programmer. I want to use