为提升您的使用体验,本站正在维护,部分功能暂时无法使用。如果本站文章无法解决您的问题,您想要向社区提问的话,请到 Twitter 上的 @FirefoxSupport 或 Reddit 上的 /r/firefox 提问,我们的支持社区将会很快回复您的疑问。

搜索 | 用户支持

防范以用户支持为名的诈骗。我们绝对不会要求您拨打电话或发送短信,及提供任何个人信息。请使用“举报滥用”选项报告涉及违规的行为。

详细了解

How do I get Firefox to use an older copy of places.sqlite to show deleted history?

  • 4 个回答
  • 5 人有此问题
  • 39 次查看
  • 最后回复者为 cbucci28

more options

I have my history set to delete when I close Firefox. Last week I visited a site that I forgot to bookmark and now cannot recall what the URL was. I have read the various entries about how to locate and recover places.sqlite posted here in Mozilla Support. Can someone please explain the next step after finding the previous version of the file? How do I get Firefox to use this restored version of the file?

Windows 7, Firefox 52.2

I have my history set to delete when I close Firefox. Last week I visited a site that I forgot to bookmark and now cannot recall what the URL was. I have read the various entries about how to locate and recover places.sqlite posted here in Mozilla Support. Can someone please explain the next step after finding the previous version of the file? How do I get Firefox to use this restored version of the file? Windows 7, Firefox 52.2

被采纳的解决方案

Could I suggest:

(A) Create a new Firefox profile, and switch over to it (B) Replace the empty places.sqlite database in the new profile with the one you want to explore (C) Complete your research in the new profile and then switch back to your normal one

That should involve the least risk of severe breakage. Here's how:

Create a New Profile

Inside Firefox, type or paste about:profiles in the address bar and press Enter/Return to load it.

Click the Create a New Profile button, then click Next. Assign a name like June2017, ignore the option to relocate the profile folder, and click the Finish button.

After creating the profile, scroll down to it and click the Set as default profile button below that profile, then scroll back up and click the Restart normally button. (There are some other buttons, but I think those are still "under construction" so please ignore them.)

Firefox should exit and then start up using the new profile, which will just look brand new.

If you normally use Firefox Sync, do NOT set up Sync in this profile. Also, do not change the settings for history.

Swap the Database

Open your new profile's Firefox profile folder using either

  • "3-bar" menu button > "?" button > Troubleshooting Information
  • (menu bar) Help > Troubleshooting Information
  • type or paste about:support in the address bar and press Enter

In the first table on the page, click the "Show Folder" or "Open Folder" button. This should launch a new window listing various files and folders in Windows Explorer.

Leaving that window open, switch back to Firefox and Exit, either:

  • "3-bar" menu button > "power" button
  • (menu bar) File > Exit

Pause while Firefox finishes its cleanup, then rename places.sqlite to something like places-old.sqlite. If you see files named places.sqlite-shm or places.sqlite-wal, which normally would not be there while Firefox is closed, delete those files.

Next, copy the old places.sqlite file from your backup into this folder. It should appear in alphabetical order right after or right before the places-old.sqlite file.

When you start Firefox, it should have the history and bookmarks from that swapped-in file instead of the stuff that a brand new Firefox has.

Create a Desktop Shortcut to the Site

When you figure out what site you wanted to bookmark, drag the "i-in-a-circle" icon to the Windows desktop and drop it there to create a shortcut. The reason for this is that creating a bookmark in your new profile won't help you after the next step...

Back to Normal

When you are done with the research, open the about:profiles page again, click the Set as default profile button for your normal profile, then click the Restart normally button to get back to it. Now you can use that desktop shortcut to load the site in your regular profile and bookmark it.

Success?

定位到答案原位置 👍 1

所有回复 (4)

more options

Those are recovering data using backup files. If your data was removed without any backups . . . . . . . . .

more options

选择的解决方案

Could I suggest:

(A) Create a new Firefox profile, and switch over to it (B) Replace the empty places.sqlite database in the new profile with the one you want to explore (C) Complete your research in the new profile and then switch back to your normal one

That should involve the least risk of severe breakage. Here's how:

Create a New Profile

Inside Firefox, type or paste about:profiles in the address bar and press Enter/Return to load it.

Click the Create a New Profile button, then click Next. Assign a name like June2017, ignore the option to relocate the profile folder, and click the Finish button.

After creating the profile, scroll down to it and click the Set as default profile button below that profile, then scroll back up and click the Restart normally button. (There are some other buttons, but I think those are still "under construction" so please ignore them.)

Firefox should exit and then start up using the new profile, which will just look brand new.

If you normally use Firefox Sync, do NOT set up Sync in this profile. Also, do not change the settings for history.

Swap the Database

Open your new profile's Firefox profile folder using either

  • "3-bar" menu button > "?" button > Troubleshooting Information
  • (menu bar) Help > Troubleshooting Information
  • type or paste about:support in the address bar and press Enter

In the first table on the page, click the "Show Folder" or "Open Folder" button. This should launch a new window listing various files and folders in Windows Explorer.

Leaving that window open, switch back to Firefox and Exit, either:

  • "3-bar" menu button > "power" button
  • (menu bar) File > Exit

Pause while Firefox finishes its cleanup, then rename places.sqlite to something like places-old.sqlite. If you see files named places.sqlite-shm or places.sqlite-wal, which normally would not be there while Firefox is closed, delete those files.

Next, copy the old places.sqlite file from your backup into this folder. It should appear in alphabetical order right after or right before the places-old.sqlite file.

When you start Firefox, it should have the history and bookmarks from that swapped-in file instead of the stuff that a brand new Firefox has.

Create a Desktop Shortcut to the Site

When you figure out what site you wanted to bookmark, drag the "i-in-a-circle" icon to the Windows desktop and drop it there to create a shortcut. The reason for this is that creating a bookmark in your new profile won't help you after the next step...

Back to Normal

When you are done with the research, open the about:profiles page again, click the Set as default profile button for your normal profile, then click the Restart normally button to get back to it. Now you can use that desktop shortcut to load the site in your regular profile and bookmark it.

Success?

more options

If you do not clear the disk cache then you might have more luck there (about:cache). It is not very likely that you can recover this history via an older copy of places.sqlite if you use "Clear history when Firefox closes". Firefox may also be keeping data in memory, so it might not have been saved at all.

more options

Thanks, jscher2000. Recovery successful.