up vote 3 down vote favorite
share [g+] share [fb]

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies and errors when executing pragma integrity_check on places.sqlite.

Now the question, how do I repair SQLite-Databases?

link|improve this question
100% accept rate
2  
For future reference, the FEBE (Firefox Environment Backup Extension) may be helpful in the future. Copies the entire profile, and packages it up as a single backup. I know it doesn't answer your question, but it may be helpful to know in the future. bit.ly/aumThw – Urda Feb 22 '10 at 15:03
feedback

2 Answers

up vote 2 down vote accepted

Well, depending on how damaged it is, repair might not be possible. Your best bet is probably to try and dump the db using sqlite, then see what you can salvage. See http://stackoverflow.com/questions/2255305/how-to-repair-a-malformed-sqlite-database

If that fails, you'll probably have to restore from backup.

link|improve this answer
Thank you. The SO post wasn't helpful since it didn't work, but the solution referenced in the link did work d:\sqlite3.exe d:\idimager.cat.db .dump | d:\sqlite3.exe d:\newdb.cat.db. All favicons are now gone, but I they're rebuilding as I visit the sites. Thanks again! – Bobby Feb 23 '10 at 8:14
feedback
up vote 0 down vote

I got the same results as dumping the db just by renaming the places.sqlite file located in the profile directory.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.