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

Fóram Tacaíochta

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

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

Postáilte

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?

Tuilleadh mionsonraí faoin chóras

Feidhmchlár

  • User Agent: Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36

Tuilleadh Eolais

jscher2000
  • Top 10 Contributor
8886 réiteach 72701 freagra

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
17774 réiteach 160764 freagra

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.

Úinéir na ceiste

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
8886 réiteach 72701 freagra

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

Úinéir na ceiste

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
8886 réiteach 72701 freagra

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
17774 réiteach 160764 freagra
See also: *https://en.wikipedia.org/wiki/PhotoRec *https://en.wikipedia.org/wiki/TestDisk

Úinéir na ceiste

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
8886 réiteach 72701 freagra

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
17774 réiteach 160764 freagra

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.