Slave is not updating some tables .....

[aftab ali]

Hi All.

Here is the slave status\G

{code}
SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.2.2.100
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: replication.002802
Read_Master_Log_Pos: 997606931
Relay_Log_File: relay.008410
Relay_Log_Pos: 245142347
Relay_Master_Log_File: replication.002802
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: DB,DB_merge
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: DB.NOTES
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: DB.STATISTICS%,DB.TRANSACTIONS%,DB.HISTORY%
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 997606931
Relay_Log_Space: 245142676
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
1 row in set (0.00 sec)


{code}


i did stop and start the slave but still not updating the slave ....


actually some of the tables are not getting the data (means not updating )




thanks .......