如何恢复刚刚删除的行在mysql？ [英] How to recover just deleted rows in mysql?

问题描述

解决方案

还有另一种解决方案，如果您的服务器上有二进制日志，您可以使用 mysqlbinlog

生成一个sql文件

  mysqlbinlog binary_log_file> query_log.sql 
  

然后搜索您丢失的行。
如果你没有激活，没有其他解决方案。下次进行备份。

Is it possible to restore table to last time with data if all data was deleted accidentally.

解决方案

There is another solution, if you have binary logs active on your server you can use mysqlbinlog

generate a sql file with it

mysqlbinlog binary_log_file > query_log.sql

then search for your missing rows. If you don't have it active, no other solution. Make backups next time.

这篇关于如何恢复刚刚删除的行在mysql？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！