We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

Avatar for Username

ابحث في الدعم

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

places.sqlite damaged and my history,bookmarks,passwords lost ..Is there a way to recover or repair it .. To recover my history again?

  • 1 (رد واحد)
  • 30 have this problem
  • 1 view
  • آخر ردّ كتبه Instructor

OnLyMozillaFan
OnLyMozillaFan
more options

Please help me!!

My History , Bookmarks, Passwords to sites all lost when my pc have viruses i did scan and delete all viruses .but when i open Firefox again all my HISTORY lost .. I thought that places.sqlite (50 mb) deleted but it still exists and i think its damaged , i tried to open with notepad or wordpad i found my old sites and history but it doesn't appear in Mozilla when i open it , its appear recent sites i have visited ONLY. tried also to move it somewhere and do overwrite on new one Firefox created but no change.

Is there a way to repair , fix or recover places.sqlite and back to normal again in mozilla? PLS HELP

Sorry for my ENG

Please help me!! My History , Bookmarks, Passwords to sites all lost when my pc have viruses i did scan and delete all viruses .but when i open Firefox again all my HISTORY lost .. I thought that places.sqlite (50 mb) deleted but it still exists and i think its damaged , i tried to open with notepad or wordpad i found my old sites and history but it doesn't appear in Mozilla when i open it , its appear recent sites i have visited ONLY. tried also to move it somewhere and do overwrite on new one Firefox created but no change. Is there a way to repair , fix or recover places.sqlite and back to normal again in mozilla? PLS HELP Sorry for my ENG

All Replies (1)

Instructor
Instructor
more options

Hi

I meeting this problem too, but you can to save all possible data from corrupted places.sqlite. Here is the solution I came to (step-by-step):

1. Download sqlite3.exe executable from "http://www.sqlite.org/download.html".

2. Create "SQlite" folder in your FireFox profile.

3. Unpack sqlite3.exe to "SQlite" folder.

4. Create three batch files in "SQlite" folder:


1. sqlite-check.cmd

sqlite3 ..\places.sqlite "PRAGMA integrity_check;"

@PAUSE


2. sqlite-dump.cmd

sqlite3 ..\places.sqlite.corrupt .dump > places.bak


3. sqlite-restore.cmd

sqlite3 ..\places.sqlite < places.bak


5. Give name "places.sqlite.corrupt" to your "places.sqlite" file. It can be already renamed by FireFox.

6. Delete "places.sqlite", "places.sqlite-shm", "places.sqlite-wal" files (all "places.sqlite*" except "places.sqlite.corrupt").

7. Run FireFox, it will create empty "places.sqlite", and close FireFox.

8. Run "2. sqlite-dump.cmd", it will save all possible data from "places.sqlite.corrupt" to "SQlite\places.bak".

9. Run "3. sqlite-dump.cmd", it will recover all saved data from "SQlite\places.bak" to an empty "places.sqlite".

10. Run "1. sqlite-check.cmd" it will check integrity of the "places.sqlite" and must write "OK".

11. Run FireFox. If all fine, files "SQlite\places.bak" and "places.sqlite.corrupt" can be deleted.

Modified by Instructor