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]
