Where did you install Firefox from? Help Mozilla uncover 3rd party websites that offer problematic Firefox installation by taking part in our campaign. There will be swag, and you'll be featured in our blog if you manage to report at least 10 valid reports!

Avatar for Username

Cari Bantuan

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

Utas ini telah diarsipkan. Silakan membuat pertanyaan baru jika Anda membutuhkan bantuan.

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

  • 1 balas
  • 30 memiliki masalah ini
  • 1 kunjungan
  • Balasan terakhir oleh 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

Semua Balasan (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.

Diperbarui oleh Instructor pada