X
Tap here to go to the mobile version of the site.
Your Firefox is out of date and may contain a security risk! Upgrade Firefox

Support Forum

Where is backup places.sqlite?

Posted

FF4 on ubuntu ... It seems apparent that FF4 maintains a backup of places.sqlite and if places.sqlite is corrupted or removed it automagically replaces the corrupt/lost file. I need to know exactly where FF is maintaining this backup info at. Anyone know? ( I DO NOT need to restore my places.sqlite. I just need to know where FF maintains the backup.)

Chosen solution

On Firefox 4 the minimum size of places.sqlite is 10MB, when you use up the 10MB it will jump in size to 20MB. This is to avoid database fragmentation and helps improve performance. The size will always be a multiple of 10MB.

Read this answer in context 3

Additional System Details

Installed Plug-ins

  • 3.0.40818.0
  • The Adobe Reader plugin is used to enable viewing of PDF and FDF files from within the browser.
  • The Totem 2.30.2 plugin handles video and audio streams.
  • DivX Web Player version 1.4.0.233
  • Shockwave Flash 10.2 r153

Application

  • User Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.16) Gecko/20110323 Ubuntu/10.04 (lucid) Firefox/3.6.16

More Information

TonyE
  • Moderator
1041 solutions 8840 answers

The backups are of the bookmarks and are inside the bookmarkbackups folder inside the profile folder. The browsing history, which is also in the places.sqlite file, is not backed up. You should find several backup files with names in the format bookmarks-yyyy-mm-yy.json

For details of how to find the profile folder see https://support.mozilla.com/en-US/kb/Profiles

Question owner

Okay, here's the bottom line reason why I am asking this question. I am in permanent private browsing mode but I keep ending up with a 10 MB places.sqlite. My bookmarks json is only 163 KB. What is places.sqlite containing that cause it to be 10 MB in size? It's surely much, much more than bookmarks.

Modified by Trapper33

TonyE
  • Moderator
1041 solutions 8840 answers

Chosen Solution

On Firefox 4 the minimum size of places.sqlite is 10MB, when you use up the 10MB it will jump in size to 20MB. This is to avoid database fragmentation and helps improve performance. The size will always be a multiple of 10MB.

Question owner

Thank you TonyE. Now I understand and there's no need for me to be concerned with the file size.