Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a way to create a .db file in SQLite Database Browser

I am using SQLite Database Browser to manage my databases.

However, I can't find a way to create a .db file out of my database.

Here is a picture of the options in SQLite Database Browser. enter image description here

In File->Export, I can only create a sql file or a CSV file.

Is there a way to create a .db file out of SQLite Database Browser ?

If no, is there any other way of doing it ?

like image 775
Pierre Avatar asked Jun 20 '14 19:06

Pierre


People also ask

How do you create a db file?

Create a blank database On the File tab, click New, and then click Blank Database. Type a file name in the File Name box. To change the location of the file from the default, click Browse for a location to put your database (next to the File Name box), browse to the new location, and then click OK. Click Create.

Can SQLite open .db files?

SQLite will check the file name “SchoolDB. db” whether it is found in the same location or not. If the file exists, it will open it.

How do I save a database as a db file?

Open the database or database object. On the File tab, click Save As. Do one of the following steps: To save a database in a different format, click Save Database As.


3 Answers

Sqlite doesn't really have a file extension. By convention, most people use sqlite3 - but you can use anything. Sqlite database is defined by the file format. (See more: http://www.sqlite.org/fileformat.html)

Is there something you're trying to accomplish specifically by using the .db format? If not, you can name it .db, or sqlite3, or whatever you'd like.

like image 172
Matches Avatar answered Oct 31 '22 06:10

Matches


Rename HearthStoneData to HearthStoneData.db.

like image 43
CL. Avatar answered Oct 31 '22 04:10

CL.


You need to find the file you are working on. Do not use "save as" . The address of the db file is in the top bar. Rename the file in the directory to .db

like image 30
D Stack Avatar answered Oct 31 '22 06:10

D Stack