X
Tap here to go to the mobile version of the site.

Support Forum

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

Posted

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?
jscher2000
  • Top 10 Contributor
8794 solutions 71943 answers

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.)

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.)
cor-el
  • Top 10 Contributor
  • Moderator
17580 solutions 159048 answers

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.

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.

Question owner

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?

''jscher2000 [[#answer-1183847|said]]'' <blockquote> 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.) </blockquote> 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?
jscher2000
  • Top 10 Contributor
8794 solutions 71943 answers

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
''fideliste [[#answer-1183923|said]]'' <blockquote>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? </blockquote> What parts of file names can you see? The most recent backups will start with bookmarks-2018-12 or from November bookmarks-2018-11

Question owner

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,...

''jscher2000 [[#answer-1183958|said]]'' <blockquote> ''fideliste [[#answer-1183923|said]]'' <blockquote>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? </blockquote> What parts of file names can you see? The most recent backups will start with bookmarks-2018-12 or from November bookmarks-2018-11 </blockquote> The problem is that I see many f23243552.sql, f564456346-sql,...
jscher2000
  • Top 10 Contributor
8794 solutions 71943 answers

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

Maybe someone familiar with using that tool will have a suggestion.
cor-el
  • Top 10 Contributor
  • Moderator
17580 solutions 159048 answers
See also: *https://en.wikipedia.org/wiki/PhotoRec *https://en.wikipedia.org/wiki/TestDisk

Question owner

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" :(

''jscher2000 [[#answer-1183993|said]]'' <blockquote> Maybe someone familiar with using that tool will have a suggestion. </blockquote> 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" :(
jscher2000
  • Top 10 Contributor
8794 solutions 71943 answers

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",

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",
cor-el
  • Top 10 Contributor
  • Moderator
17580 solutions 159048 answers

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

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