Why has content-prefs.sqlite has gone from 14MB to 55MB ?

[darkred]

Thanks to all trying to help.

Maybe load the file into a sqlite manager and vacuum it.

I just tried in Sqlite Manager>Compact, and the file remains exactly the same!

Code: Select all

The database was compacted using VACUUM statement.
Before compacting:
   Page Count    = 1692
   Database Size = 55443456 bytes
After compacting:
   Page Count    = 1692
   Database Size = 55443456 bytes

Also, checking it's integrity (both quickly and full) shows that there's no problem.

[patrickjdempsey]

content-prefs.sql contains page zoom data as well as download and upload folder locations. https://developer.mozilla.org/en-US/doc ... references

So either you've been zooming in on websites or doing a lot of downloads or uploads in that period.

[darkred]

content-prefs.sql contains page zoom data as well as download and upload folder locations. https://developer.mozilla.org/en-US/doc ... references

So either you've been zooming in on websites or doing a lot of downloads or uploads in that period.

No, I never tweak zoom level for any site.

Also, yes, I might have done a lot of downloads,
but almost all of them were stored to the same folder (either C:\Users\username\Downloads or C:\Users\username\Desktop), I rarely change the location.
And, I just cleared Downloads in Library, but content-prefs.sql remains exactly the same.

[patrickjdempsey]

I don't think that data is cleared with Downloads... Download history is stored in places.sqlite.

But really you are the only person who can answer this question by opening up the two files in the SQLite manager and comparing them.

[redwolfe_98]

zakk, maybe using backed up profiles is the cause of the problem(s)?

i don't see a need to back up a whole profile.. in my opinion, all you need to back up is your bookmarks..

[dfoulkes]

Assuming that the restoring of a backed up profile is done the normal way... I don't see how that would affect
a file like that... something else is going one. ... and just backing up stuff should not affect anything like that.

I guess it would be interesting to defrag the file... just to see what happens? ... zakk do you have a defraggler? ... I use this one...just stabbing in the dark here...
Defraggler - File and Disk Defragmentation - Free Download

Also... you could always close out Firefox, copy that file to a safe place ... maybe make a new folder under your misc. areas... delete the one in your profile and start Firefox back up... it will/should create the missing file... check its size and watch it for a while to see if it grows.

[darkred]

Assuming that the restoring of a backed up profile is done the normal way... I don't see how that would affect
a file like that... something else is going one. ... and just backing up stuff should not affect anything like that.

This is how I restore a profile:

What I do is I backup in a daily basis this folder
C:\Users\User\AppData\Roaming\Mozilla
into a ZIP file.

So, to restore the profile (I've only restored the profile only a few times - after Firefox hang.):
I delete the existing folders:
C:\Users\User\AppData\Roaming\Mozilla and
C:\Users\User\AppData\Local\Mozilla.
Then I unzip the backup file to it's initial path.

So, I also don't think that this may have caused this.

I guess it would be interesting to defrag the file... just to see what happens? ... zakk do you have a defraggler? ... I use this one...just stabbing in the dark here...
Defraggler - File and Disk Defragmentation - Free Download

Defraggler didn't help, the file remained exactly as it is.

Also... you could always close out Firefox, copy that file to a safe place ... maybe make a new folder under your misc. areas... delete the one in your profile and start Firefox back up... it will/should create the missing file... check its size and watch it for a while to see if it grows.

So, that's what I did: I took backup of the file, and then deleted it.
It got recreated (224 KB) and Firefox works well with no issues.

Thanks a lot, dfoulkes
and to all who contributed to my thread.

[dfoulkes]

You're Welcome!

[vessto]

My content-prefs.sqlite is 500 MB. What can I do?

[LIMPET235]

You could try the suggestions in this year old thread.

Locking due to old age...