Why do you want to open an .sqlite file?

• SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/

i want to access my bookmarks in a previous firefox profile file. it is an .sqlite file. will sqlite manager do this? why the adobe error message?

thanks for your help.

It is best to use the Firefox Bookmarks Manager to access bookmarks from such a places.sqlite file for inspection. You can see the content in SQLite Manager, but you see the raw data and see all tables separately and won't be able to make much sense of it.

You can use a separate profile and copy the file to that profile and export the bookmarks to an HTML file if you do not want to replace the bookmarks your current bookmarks. Switching the files temporarily in your current profile is also possible provided that the places.sqlite file is not corrupted.

• Help > Troubleshooting Information > Profile Directory: Open Containing Folder
• http://kb.mozillazine.org/Backing_up_and_restoring_bookmarks_-_Firefox

" Help > Troubleshooting Information > Profile Directory: Open Containing Folder" . i can't find open containing folder in profile directory. it does give me the option to open the places.sqlite file using graphic converter. when i try that, graphic converter gives me a window saying that it can't be opened because it is corrupted or is not a file type supported by graphic converter.

i appreciate your help with a workaround to get the old bookmarks. that works. however, the problem has morphed from that concern to why adobe reader [the default app.] won't open firefox .sqlite files. is the problem in adobe reader or firefox? also, how can i tell if the places.sqlite file is corrupt?

i'm getting in over my head here and do appreciate your help.

You can only open sqlite database files with a program that can handle that file format. Graphic converter and Adobe Reader (PDF) programs can't handle that and will give an error. I do not know why you get the choice to use those programs for sqlite files.

thank you. after banging my head against the wall a while longer, i've come to understand that ff4 .sqlite files are not meant to be and do not need to be opened to repair them.

still, i wonder why they are designated adobe reader apps in the finder.