Hilfe durchsuchen

Vorsicht vor Support-Betrug: Wir fordern Sie niemals auf, eine Nummer anzurufen, sie per SMS zu kontaktieren oder persönliche Daten preiszugeben. Bitte melden Sie verdächtige Aktivitäten über die Funktion „Missbrauch melden“.

Learn More

Question abou SQLite

more options

Hello,

I have a Dell Windows 10 laptop. I read that the Firefox bookmarks are stored in the places.sqlite database. I deleted places,sqlite from the Old Firefox Data> vs1vf21j.default-1591989997105 folders, but when I opened my Firefox browser, the bookmarks were still there. Is this the place where bookmarks are stored?

Thank you

Hello, I have a Dell Windows 10 laptop. I read that the Firefox bookmarks are stored in the places.sqlite database. I deleted places,sqlite from the Old Firefox Data> vs1vf21j.default-1591989997105 folders, but when I opened my Firefox browser, the bookmarks were still there. Is this the place where bookmarks are stored? Thank you

Ausgewählte Lösung

You can use the button on the "Help -> More Troubleshooting Information" (about:support) page to go to the current Firefox profile folder or use the about:profiles page (Root directory).

Diese Antwort im Kontext lesen 👍 1

Alle Antworten (16)

more options

Hi, Old Firefox Data contains profile folders from when the Refresh function ran. Those are not in active use and are just for your reference in recovering data if the Refresh didn't carry forward the data it was supposed to carry forward.

Is your goal to delete your bookmarks only, or bookmarks and history both? The database stores both. If you only want to delete one or the other, you can use the Library window. For example:

  • Call up Manage bookmarks (Ctrl+Shift+O as in "Organizer")
  • Firefox will display the contents of Other Bookmarks automatically
  • Press Ctrl+A to "Select All"
  • Press the Delete key to delete the selected bookmarks
  • Click Bookmarks Menu in the left column to display its contents on the right, and repeat the Select All, Delete
  • Click Bookmarks Toolbar in the left column to display its contents on the right, and repeat the Select All, Delete

If you have regrets, one of the menus in the Library window has an Undo command.

Or if you want to work with files in your profile folder directly, see the following article for how to access them (they are in a hidden folder path): Profiles - Where Firefox stores your bookmarks, passwords and other user data.

more options

Ausgewählte Lösung

You can use the button on the "Help -> More Troubleshooting Information" (about:support) page to go to the current Firefox profile folder or use the about:profiles page (Root directory).

more options

Thank you jscher2000 and cor-el for the great information. I am very new to SQLite, I am going to study this information, but it may take me a while before I get it. The reason that I was looking at SQLite in the first place, is because I have about 100 bookmarks on my old Windows 10 laptop that I wanted to transfer to my new computer. But the old desktop screen is not showing any information, just a blank screen. But the command prompt does come up, and I am able to access files and folders there.

Thank you again !

more options

Note that your old profile folder is along a hidden path. You can jump into it with this at the command prompt:

cd %APPDATA%\Mozilla\Firefox\Profiles

At that point you'll need to

dir

to find the specific folder name to cd into.

more options

Thank you for the great information jscher2000 !

more options

I do have another question:

What do the percentage signs surrounding APPDATA do?

%APPDATA%

Thank you

more options

The % signs are used to indicate that the text inside is a variable that points to a path in Windows. There's also %desktop%, %downloads%, and many others.

more options

Thanks again for the great information Jscher2000 !

more options

Hi Jsher2000,

I typed cd %APPDATA%\Mozilla\Firefox\Profiles into the command prompt, and pressed enter.

Two directories popped up. Would my bookmarks be in either one of these directories?

Thank you for the help !

command prompt

more options

Yes, one of those directories is likely to be the recently active one. I don't think there is any shortcut -- you need to type cd and then the long name to get into that directory and look for the desired files.

Or actually, you might be able to use copy or xcopy to copy the whole folder to a USB drive or whatever other method you were going to use to copy over the files.

more options

Thank you !

Am I looking for the folder or table: places.sqlite?

more options

places.sqlite is a file. It has a companion favicons.sqlite file with the site icons.

More info on the various things you'll find in a profile folder: Recovering important data from an old profile

more options

I found and recovered both files.

THANK YOU SO MUCH ! ! !

HAVE A GREAT YEAR ! !  !

more options

Hi Jscher2000

I couldn't figure out how to open the files manually, so I used the SysTools SQLite app to open the files. The only thing, I do not see the URLs. Would you know how I would see the links using this app?


Thanks again

more options

The moz_bookmarks table has a column pointing to the ID of a record in the moz_places table. That turns out to be the fk column (presumably short for foreign key).

Does that tool allow you to run a query? If so, you could start with the basic join:

SELECT moz_bookmarks.title, moz_places.url FROM 'moz_bookmarks' INNER JOIN 'moz_places' ON moz_bookmarks.fk = moz_places.id ORDER BY moz_places.url

(There are no links intended, please ignore any linkification.)

more options

By the way, why read the files directly? It would be simpler to let Firefox do this for you. You could run a backup and export of what you have now "just in case", then replace your current places.sqlite and favicons.sqlite files with your recovered ones (while Firefox is not running).