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

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

  • 10 replies
  • 1 has this problem
  • 16 views
  • Last reply by 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?

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.