Search Support

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

Cuireadh an snáithe seo sa chartlann. Cuir ceist nua má tá cabhair uait.

Guess where places.sql is in many *.sql files

  • 10 bhfreagra
  • 1 leis an bhfadhb seo
  • 1 view
  • Freagra is déanaí ó cor-el

more options

I need to recognize places.sql. I deleted partition but recovered many .sql files (about 1000) but I don't know which is places.sql. How can i find?

I need to recognize places.sql. I deleted partition but recovered many .sql files (about 1000) but I don't know which is places.sql. How can i find?

All Replies (10)

more options

You're looking for the Places database file that stores history and bookmarks?

The file name is exactly places.sqlite -- with no additional text like -shm, -wal, or corrupt after sqlite (those are not useful files).

On Windows Vista, your profiles would have been under the hidden path:

C:\Users\Windows-user-name\AppData\Roaming\Mozilla\Firefox\Profiles

Make sure Windows is set to show hidden files and folders: https://support.microsoft.com/en-us/help/14201/windows-show-hidden-files

If you can live without history and want the bookmarks, look for files whose names match this pattern:

bookmarks-2018-12-24_3550_gibberish==.jsonlz4

(In this example, 3550 represents 3,550 items in the file.)

more options

If you recover (undelete) a file then there is no guarantee that the recovered file isn't corrupted and would work. With a file like places.sqlite that is 5 MB by default and if necessary incremented by 5 MB chunks the risk is much higher.

more options

jscher2000 said

You're looking for the Places database file that stores history and bookmarks? The file name is exactly places.sqlite -- with no additional text like -shm, -wal, or corrupt after sqlite (those are not useful files). On Windows Vista, your profiles would have been under the hidden path: C:\Users\Windows-user-name\AppData\Roaming\Mozilla\Firefox\Profiles Make sure Windows is set to show hidden files and folders: https://support.microsoft.com/en-us/help/14201/windows-show-hidden-files If you can live without history and want the bookmarks, look for files whose names match this pattern: bookmarks-2018-12-24_3550_gibberish==.jsonlz4 (In this example, 3550 represents 3,550 items in the file.)

Thank you. Bookmarks is what i want, that's correct. For recovering, I used Photorec in linux but in the selection of Type file there isn't the extension ".jso". So i don't know how to do to try to recover *.jsonlz4. Would you have any suggest?

more options

fideliste said

Bookmarks is what i want, that's correct. For recovering, I used Photorec in linux but in the selection of Type file there isn't the extension ".jso". So i don't know how to do to try to recover *.jsonlz4. Would you have any suggest?

What parts of file names can you see? The most recent backups will start with

bookmarks-2018-12

or from November

bookmarks-2018-11
more options

jscher2000 said

fideliste said
Bookmarks is what i want, that's correct. For recovering, I used Photorec in linux but in the selection of Type file there isn't the extension ".jso". So i don't know how to do to try to recover *.jsonlz4. Would you have any suggest?

What parts of file names can you see? The most recent backups will start with

bookmarks-2018-12

or from November

bookmarks-2018-11

The problem is that I see many f23243552.sql, f564456346-sql,...

more options

Maybe someone familiar with using that tool will have a suggestion.

more options
more options

jscher2000 said

Maybe someone familiar with using that tool will have a suggestion.

Now I have recovered .json, these are 31 items from 1KB to 13 KB. I tried to select one at a time by the menu Restore of firefox but the message is always the same: "unable to process the backup file" :(

more options

A .json file is a plain text file, and you could view it in a text editor.

A .jsonlz4 file is a compressed file that you will need to decompress to view. You can use the bookbackreader.html tool for that (assuming the file is not corrupted).

The beginning of a bookmark backup file looks like this (one space added to allow the line to break here):

{"guid":"root________","title":"","index":0,"dateAdded":1219946831611000, "lastModified":1545775122681000,"id":1,"typeCode":2,"type":"text/x-moz-place-container","root":"placesRoot",

more options

A compressed .jsonlz4 backup starts with "mozLz40" (6D6F7A4C7A3430) as you can see if you inspect such a file in a hex viewing utility.