Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to open this .DB file? [closed]

Tags:

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.

like image 606
Croo Avatar asked May 20 '13 18:05

Croo


People also ask

How do I read .DB files?

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.

How do I open a .DB file in my browser?

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.

What app opens a .DB file?

Applications like Microsoft Access, Design Compiler Graphical, and LibreOffice use them routinely and can open the . db files they create.

How do I open a .DB file in MySQL?

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.


2 Answers

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"

like image 64
Jerry Avatar answered Sep 19 '22 15:09

Jerry


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.

like image 37
Scott Chamberlain Avatar answered Sep 16 '22 15:09

Scott Chamberlain