Avatar for Username

Pesquisar no apoio

Evite burlas no apoio. Nunca iremos solicitar que telefone ou envie uma mensagem de texto para um número de telefone ou que partilhe informações pessoais. Por favor, reporte atividades suspeitas utilizando a opção "Reportar abuso".

Saber mais

Esta discussão foi arquivada. Se precisar de ajuda, por favor, coloque uma nova questão.

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

  • 1 resposta
  • 30 têm este problema
  • 1 visualização
  • Última resposta por 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

Todas as respostas (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.

Modificado por Instructor a