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
'[EMAIL PROTECTED]:3306', replication started in log
'mysql-bin.000003' at position 4608829
any ideas as to why they are not all updating ?
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
