After trying to clear recent history places.sqlite corrupted
Last night I cleared the last hour of my browsing history (all settings ticked). The clear finished instantly, which I found odd as there's usually a delay.
There were no immediate symptoms until after I turned on my computer today, all history/cookies/etc were gone.
I found a places.sqlite.corrupt with a filesize of 20,480 kB and a replacement places.sqlite with a filesize of 10,240 kB in my sole profile folder.
Because the corrupted file is exactly twice the size of the uncorrupted file I imagine that what happened is that some point early on in the clear recent history operation the contents were duplicated but for some reason the process didn't finish. I'm hoping that everything is still there but I cannot use the places.sqlite.corrupt to check.
I do not have any backups or sync to work with, and renaming the .corrupt file to places.sqlite (after deleting the replacement) does not work.
Any help would be greatly appreciated, I am willing and able to get down and dirty with sqlite repair, so do not shy away from overly technical solutions if you know any.
Όλες οι απαντήσεις (3)
I've done a lot of work on the corrupted places.sqlite, but unfortunately it doesn't seem to have my history on it either.
Still if anyone has any ideas...
Attempted that already: It reported that the integrity_check was OK, which the guide says means the guide can't help you. Firefox just doesn't like the .sqlite for some reason.
Recompiling the .sqlite to .sql showed a file that had no ERROR statements. Strangely though I could not recompile the .sql back to .sqlite, it kept saying that the PRAGMA statements at the start of the file were invalid syntax.