I have a few database files with .db extension and I want to take a peek. However I don't know what program should I use to open the files. I've found a similar quesiton that says checking the header of the db file could reveal the name of the database-program/type. What I've found is "FLDB". Anyone have any clue what kind of database file can this be?
Edit:
Trying to give more hint: This is a program of a car navigation system and it knows 8 languages. I'm trying to localize it to my language. There are lots of .db and two .gdb files witch (probably) contains this data.
Many types of DB files are not meant to be opened by users. However, if your DB file is a SQLite database, you can open it and view the data it contains with SQLite Database Browser. Keep in mind that, if your DB file is encrypted, you will not be able to open it unless you know the encryption password.
To open the database in DB Browser do the following; Click on the 'open database' button in the toolbar. Navigate to where you have stored the database file on your local machine, select it and click open.
Applications like Microsoft Access, Design Compiler Graphical, and LibreOffice use them routinely and can open the . db files they create.
Can I open a DB file in MySQL? Yes. In the MySQL Workbench, go to MySQL Connections and enter the database information. Once connected to the database, go to Data Import/Restore and select Import from Self-Contained File.
I don't think there is a way to tell which program to use from just the .db extension. It could even be an encrypted database which can't be opened. You can MS Access, or a sqlite manager.
Edit: Try to rename the file to .txt and open it with a text editor. The first couple of words in the file could tell you the DB Type.
If it is a SQLite database, it will start with "SQLite format 3"
You can use a tool like the TrIDNet - File Identifier to look for the Magic Number and other telltales, if the file format is in it's database it may tell you what it is for.
However searching the definitions did not turn up anything for the string "FLDB", but it checks more than magic numbers so it is worth a try.
If you are using Linux File is a command that will do a similar task.
The other thing to try is if you have access to the program that generated this file, there may be DLL's or EXE's from the database software that may contain meta information about the dll's creator which could give you a starting point for looking for software that can read the file outside of the program that originally created the .db
file.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With