
Guess where places.sql is in many *.sql files
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?
تمام جوابات (10)
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.)
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.
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?
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
jscher2000 said
fideliste saidBookmarks 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-12or from November
bookmarks-2018-11
The problem is that I see many f23243552.sql, f564456346-sql,...
Maybe someone familiar with using that tool will have a suggestion.
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" :(
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 compressed .jsonlz4 backup starts with "mozLz40" (6D6F7A4C7A3430) as you can see if you inspect such a file in a hex viewing utility.