database 如何打开这个 .DB 文件？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/16656037/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to open this .DB file?
提问by Croo
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?
我有几个扩展名为 .db 的数据库文件，我想看一看。但是我不知道应该使用什么程序来打开文件。我发现了一个类似的问题，它说检查 db 文件的标题可以揭示数据库程序/类型的名称。我发现的是“FLDB”。任何人都知道这是什么类型的数据库文件？
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.
试图给出更多提示：这是一个汽车导航系统程序，它知道8种语言。我正在尝试将其本地化为我的语言。有很多 .db 和两个 .gdb 文件（可能）包含这些数据。
回答by Jerry
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.
我认为没有办法仅从 .db 扩展名中判断要使用哪个程序。它甚至可能是一个无法打开的加密数据库。您可以使用 MS Access 或 sqlite 管理器。
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.
编辑：尝试将文件重命名为 .txt 并使用文本编辑器打开它。文件中的前几个词可以告诉您 DB 类型。
If it is a SQLite database, it will start with "SQLite format 3"
如果是SQLite数据库，会以“SQLite format 3”开头
回答by Scott Chamberlain
You can use a tool like the TrIDNet - File Identifierto look for the Magic Numberand other telltales, if the file format is in it's database it may tell you what it is for.
您可以使用像TrIDNet - 文件标识符这样的工具来查找幻数和其他迹象，如果文件格式在其数据库中，它可能会告诉您它的用途。
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.
然而，搜索定义并没有发现字符串“FLDB”的任何内容，但它检查的不仅仅是幻数，所以值得一试。
If you are using Linux Fileis a command that will do a similar task.
如果您使用的是 Linux File是一个可以完成类似任务的命令。
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 .dbfile.
另一件要尝试的事情是，如果您有权访问生成此文件的程序，则数据库软件中可能有 DLL 或 EXE，其中可能包含有关 dll 创建者的元信息，这可以为您提供一个起点来寻找可以在最初创建.db文件的程序之外读取文件。
