I have been struggling with one way replication for weeks, still can't make it work.
I used windows, MySql 4.0.17 version on both. I have set bin-log option in my.cfg in master computer, in slave computer, set master-host, master-user=repl,master-password, replicate-do-db=test and replicate-ignore-db=mysql, skip-slave-start in my.cfg. I have zipped the database from master, copy the zip to slave and unzip it, then I start master server, after I set all privileges for repl in master server, I start slave. When I do some update in master computer in database, the query ( update test.experiement set ......, database is specified in the query) showed in master-bin.001 and it is shown in slave-relay-bin.001 too (slave IO thread is working), but test database in slave doesn't update. What could be wrong? I have donw show slave status, SQL thread seems to be running too, but why it doesn't execute the query from liyingtop-realy-bin.001? I wonder if anyone has experienced the similar situation and know what's wrong with what I did. Liying > > > > *************************** 1. row *************************** > > Master_Host: lhuang > > Master_User: repl > > 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: test > > 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) > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
