如何恢复损坏的 SQLite3 数据库?
这是之前回答的帖子的后续问题:是否有用于在 Linux 中验证 SQLite 数据库的命令行实用程序?
This is a follow up question to a previously answered post: Is there a command line utility for validating SQLite databases in Linux?
如果数据库产生以下错误:
If a database is producing the following error:
$ sqlite3 mydata.db "PRAGMA integrity_check"
Error: database disk image is malformed
是否有任何清理处理可以将数据库恢复到可用状态?即使可能会丢失一些损坏的记录?
Is there any cleanup processing that can be done to recover the database to a usable state? Even at the potential loss of some corrupt records?
谢谢
推荐答案
UPDATE:现在有一个自动方法内置于 SQLite:.recover
UPDATE: There is now an automatic method that is built into SQLite: .recover
有时,损坏仅或大部分出现在索引中,在这种情况下,通过尝试使用 .dump
转储整个数据库,可以获取部分或大部分记录,并使用这些命令来创建一个新的数据库:
Sometimes, the corruption is only or mostly in indexes, in which case it would be possible to get some or most records by trying to dump the entire database with .dump
, and use those commands to create a new database:
$ sqlite3 mydata.db ".dump" | sqlite3 new.db
然而,这并不总是可行的.
However, this is not always possible.
最简单、最可靠的方法是从备份中恢复数据库文件.
The easiest and most reliable way is to restore the database file from the backup.
相关文章