Hi Tom, Your master binary log start with mysql-bin.000003, then, your insert ( or update) in the master could be in mysql-bin.000002 or 1.
Please, reload your binary logs again from the beginning ( put mysql-bin.000002 or 1, ). Your insert or update could be in one of this files. Regards, Juan On Fri, May 16, 2008 at 10:09 AM, Tom Brown <[EMAIL PROTECTED]> wrote: > > >> Yes thanks - i have done that and restarted the slave and _some_ tables >> now appear to update but others dont >> >> eg >> >> master: >> mysql> select count(*) from tbl_checkcommand; >> +----------+ >> | count(*) | >> +----------+ >> | 30 | >> +----------+ >> 1 row in set (0.00 sec) >> >> slave: >> mysql> select count(*) from tbl_checkcommand; >> +----------+ >> | count(*) | >> +----------+ >> | 0 | >> +----------+ >> 1 row in set (0.00 sec) >> >> all seems ok in the log >> >> 080516 12:21:55 [Note] Slave SQL thread initialized, starting replication >> in log 'mysql-bin.000003' at position 2941, relay log >> './devsw19nagios02-relay-bin.000001' position: 2909 >> /usr/libexec/mysqld: ready for connections. >> Version: '4.1.20' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source >> distribution >> 080516 12:21:55 [Note] Slave I/O thread: connected to master ' >> [EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.000003' >> at position 4608829 >> >> any ideas as to why they are not all updating ? >> >> >> > i should probabbly also mention that the slave appears to think its happy, > i believe, > > mysql> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: Waiting for master to send event > Master_Host: 192.168.12.225 > Master_User: repl > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: mysql-bin.000003 > Read_Master_Log_Pos: 6412734 > Relay_Log_File: devsw19nagios02-relay-bin.000002 > Relay_Log_Pos: 1803952 > Relay_Master_Log_File: mysql-bin.000003 > Slave_IO_Running: Yes > Slave_SQL_Running: Yes > Replicate_Do_DB: > Replicate_Ignore_DB: > Replicate_Do_Table: > Replicate_Ignore_Table: > Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 0 > Last_Error: > Skip_Counter: 0 > Exec_Master_Log_Pos: 6412734 > Relay_Log_Space: 1803952 > 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) > > >
