General > Off-Topic

Recover SQLite DB?

(1/1)

Tw2Stefan:
Hey y'all, long story short I have an sv.db that's nearly 1gb. Obviously that's a bit too much for a server so I attempted to recover the data and transfer it out. The DB is so corrupt that VACUUM doesn't work and dumping the data to SQL files didn't work.

Do y'all have any methods of recovering old sv.db that I should try?

Timmy:
According to the SQLite FAQ (https://www.sqlite.org/faq.html#q21):

--- Quote ---Depending how badly your database is corrupted, you may be able to recover some of the data by using the CLI to dump the schema and contents to a file and then recreate. Unfortunately, once humpty-dumpty falls off the wall, it is generally not possible to put him back together again.
--- End quote ---

What is the output of the command below? (Make sure you have sqlite3 installed.)

--- Code: ---$ sqlite3 sv.db "PRAGMA integrity_check"
--- End code ---

Can you clarify what you mean by “didn’t work”? Did an error occur when dumping the data? Was only part of the data recovered?

Navigation

[0] Message Index