I stopped both server, clean all log, master.info etc files in mysql\data. And changed repicate-do-db=WITCD, one database this time, start servers in both computer, use WITCD in both computer, start slave in slave computer, then do an update in master (same query), no update in database for slave 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 either the WITCD or WITTD database? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/12/04, 9:52:57 AM, Liying Huang <[EMAIL PROTECTED]> wrote regarding Re; Re: question for replication: > 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-bin.001 > Relay_Log_Pos: 120 > Relay_Master_Log_File: lhuang-bin.001 > Slave_IO_Running: Yes > Slave_SQL_Running: Yes > Replicate_do_db: WITCD,WITTD > Replicate_ignore_db: mysql > Last_errno: 0 > Last_error: > Skip_counter: 0 > Exec_master_log_pos: 79 > Relay_log_space: 116 > 1 row in set (0.00 sec) > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "Liying Huang" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>Sent: Thursday, February 12, 2004 10:28 AM > Subject: Re: question for replication > What is the output from show slave status? > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > On 2/12/04, 8:43:44 AM, Liying Huang <[EMAIL PROTECTED]> wrote > regarding question for replication: > > Hi, > > I tried to do replication from master-> slave, I used windows, > > MySql 4.0.17 version on both. I have set bin-log option > > in my.cfg in master computer, set master-host, master-user, > master-password, > > replicate-do-db and replicate-ignore-db=mysql, skip-slave-start in > > my.cfg in slave. I have zipped the database from master, copy the zip to > > slave and unzip it, then I start both server, start slave. When I do some > > update in master computer in database, the query showed in master-bin.001 > > and it is shown in slave-relay-bin.001 too (slave IO thread seems > working), > > but database in slave doesn't update. What have I done wrong? The > database > > is > > not small, it will take forever if I use 'load data from master', so I > > copy the database instead. The outcome from "Show processlist\G" > > is attached below too. It seems slave SQL thread is running without > problem. > > Liying > > > *************************** 1. row *************************** > > > Id: 1 > > > User: test > > > Host: localhost:1110 > > > db: NULL > > > Command: Query > > > Time: 0 > > > State: NULL > > > Info: show processlist > > > *************************** 2. row *************************** > > > Id: 2 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 7 > > > State: Waiting for master to send event > > > Info: NULL > > > *************************** 3. row *************************** > > > Id: 3 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 7 > > > State: Has read all relay log; waiting for the I/O slave thread to > > update > > > it > > > Info: NULL > > > 3 rows in set (0.02 sec) > > > > > > After I do some update in master, show processlist\G gives me: > > > > > > *************************** 1. row *************************** > > > Id: 1 > > > User: test > > > Host: localhost:1110 > > > db: NULL > > > Command: Query > > > Time: 0 > > > State: NULL > > > Info: show processlist > > > *************************** 2. row *************************** > > > Id: 2 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 323 > > > State: Waiting for master to send event > > > Info: NULL > > > *************************** 3. row *************************** > > > Id: 3 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 7 > > > State: Has read all relay log; waiting for the I/O slave thread to > > update > > > it > > > Info: NULL > > > > > > The time for id 2 and 3 are very differnet. > > > > > -- > > 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] -- 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]
