取消删除Sqlite3中意外删除的记录 [英] Undelete accidentally deleted records in Sqlite3

问题描述

作为标题，可能吗?由于我在 FireFox 中丑陋的 html 界面，我不小心删除了另一条记录.不好的是这个记录删除是一个根文件夹，程序会自动级联删除所有内容:(

As title, possible? I have by accident deleted another record due to my ugly html interface in FireFox. The bad thing is this record delete is a root folder which the program automatically cascade delete everything :(

推荐答案

看看 undark.我已经用过了.如果记录没有被覆盖，它可以从 SQLite db 文件中导出行(已删除或未删除).最新版本此处.

Take a look at undark. I already used it. It it can export the rows (deleted or not) from a SQLite db file if the records were not overwritten. Last version here.

SQLite-Deleted-Records-Parser 没有给出相同的类型输出，但可能很有用.

The SQLite-Deleted-Records-Parser does not give the same type of output, but can be useful.

还有一些产品，例如 SQLite Forensic Explorer、SQLite 修复, Sqlite 数据库恢复 和 SQLiteDoctor.

And there are also some products like the SQLite Forensic Explorer, SQLite Repair, Sqlite Database Recovery and SQLiteDoctor.

如果您是开发人员，您可以使用 litereplica 避免再次遇到同样的问题.它为 SQLite 添加了单主复制.

If you are a developer you can avoid having the same problem again using litereplica. It adds single-master replication to SQLite.

但请记住启用时间点恢复，因为当事务被复制到副本时，一个意外的命令，如 DROP TABLE 或 DELETE FROM 也将被复制.使用 PITR，您将能够转到上一个时间点.

But remember to enable the point-in-time recovery because as the transactions are replicated to the replicas an accidental command like DROP TABLE or DELETE FROM will also be replicated. With PITR you will be able to go to a previous point-in-time.

或者定期使用备份 API.虽然它在每个备份上传输整个数据库.

Or use the Backup API regularly. Although it transfers the entire db on each backup.

请记住:如果您在事务处于活动状态时复制 SQLite 文件或使用常规备份方法副本可能已损坏.

And remember: if you copy an SQLite file or use a regular backup approach while a transaction is active the copy can be corrupted.

这篇关于取消删除Sqlite3中意外删除的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！