求助二进制日志恢复误删除语句的问题
问题是这样:mysql开启了二进制日志,昨天误操作将一些mysql记录误删除了,现在想通过二进制日志恢复!mysql二进制里有一条delete语句,现在想通过二进制日志恢复:但是报这个错
Duplicate entry '5181' for key 'PRIMARY'
应该怎么做?
mysqlbinlog --stop-position='889107' arb/mysql/mysql-bin.000031|mysql -uroot -p
ERROR 1062 (23000) at line 27: Duplicate entry '5178' for key 'PRIMARY'
mysqlbinlog --start-position='889189' arb/mysql/mysql-bin.000031|mysql -uroot -p
ERROR 1062 (23000) at line 27: Duplicate entry '5181' for key 'PRIMARY'
这样相同做主键的ID会报错,怎么解决?
页:
[1]