when i use mysqlbinlog to revert data,i meet this error,i don`t find any answer,please help me!

[root@localhost test]# mysqlbinlog --no-defaults  --start-datetime="2021-06-08 00:32:49"  --stop-datetime="2021-06-08 00:32:50"  /data/mysql5.6.27/data/mysql-bin.*** | mysql -uroot -p 
Enter password: 
ERROR 1032 (HY000) at line 31: Can't find record in 'table_name'
New contributor
linn Herewe is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • have you chekc that the date is in the bin log you have as starting point – nbk Jun 7 at 18:49

Your Answer

linn Herewe is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.