Hello.
Could you examine slave relay log and master binary log to find which statement
causes duplicated entry with mysqlbinlog utility. Which versions of MySQL
do you use on your master and slave? See:
http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html
http://dev.mysql.com/doc/mys
Dear mysql@lists.mysql.com:
Our db is the innodb eng.
We have no hot backup tools to dump the data.
If lock the table by the following cmd before we dump the data
FLUSH TABLES WITH READ LOCK;
It seems ok,it can lock the innodb too.
But the replication would be crushed ,even it start up smoothly,