Tìm kiếm hỗ trợ

Tránh các lừa đảo về hỗ trợ. Chúng tôi sẽ không bao giờ yêu cầu bạn gọi hoặc nhắn tin đến số điện thoại hoặc chia sẻ thông tin cá nhân. Vui lòng báo cáo hoạt động đáng ngờ bằng cách sử dụng tùy chọn "Báo cáo lạm dụng".

Learn More

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

  • 10 trả lời
  • 1 gặp vấn đề này
  • 1 lượt xem
  • Trả lời mới nhất được viết bởi 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?

Tất cả các câu trả lời (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.