.DB file extension - Which database?

Question

I have a database file with the extension .DB. I was googling and it looks like SQLite. I tried to connect to it using SQLite and SQLite3 drivers, and I get the error message "The file is encrypted or there is no database."

Therefore, I do not know if the file is encrypted or not a SQLite database. Are there any other options what the .DB extension should be? How do I know if a file is encrypted?

I tried to open it in a text editor, and this is basically a robe charaters, and sometimes words appear. I uploaded the file here: http://cl.ly/3k0E01373r3v182a3p1o for a closer look.

Thank you for your tips and ideas on what to do and how to work with this file.

Answer 1

Marco Pontello TrID is a great way to determine the type of any file.

TrID is easy to use. Just run TrID and point it to a file for analysis. The file will be read and compared with the definitions in the database. Results are presented in order of highest probability.

Just load the executable file and the last definition file into the same directory, and then run TrID:

trid.exe "path/to/file.xyz" 

It will display a list of possible file types for a file with a confidence rating. Here's a screenshot using TrID to parse a SQLite database file:

There is also a version of the GUI called TrIDNet :

Answer 2

If you are using a Unix-like platform (Mac OS X, Linux, etc.), you can try running file myfile.db to see if it can figure out what type of file it has. The file utility will check the beginning of the file, look for any hints such as magic numbers, headers, etc., to determine the type of file.

Answer 3

Look at the first 30 bytes of the file (open it in Notepad or Notepad ++ or in another simple text viewer). Usually there is a tag or extension.

Both SQLite 2 and SQLite 3 have a very clear message: "SQLite format 3" for SQLite 3 (obviously) and "** This file contains an SQLite 2.1 database **" for SQLite 2.

change
Non-encrypted SQLite databases do not have such a header because the entire file is encrypted. See siyw Comment below.

Answer 4

On a Unix-like system (or Cygwin on Windows), the strings utility will look for a file for strings and print them to stdout. May help you narrow the field.

There are many programs besides database programs that use the db extension, including

• ArcView Feature Database File (ESRI)
• Multiedit
• Netscape
• Palm

etc. Google "file extensions" for some sites that expand directory files and programs that use them.

Answer 5

There is no convincing way to find out, because SQLite encrypts the entire database file, including the header.

In addition, there are not many differences for you, except for the possible error text for the user if you request a password from them.