>
> The error 1062 you could skipped in the slave modifying your my.cnf ( slave
> side) using :
>
> slave-skip-errors=1062
>
> This error on duplicated records, normally is problem in binarylogs transfer
> data. But, anyway, please confer that the data exist in the slave.
>
>
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
'repl@stripped:3306', replication started in log
'mysql-bin.000003' at position 4608829
any ideas as to why they are not all updating ?
thanks
