Save SQLite DB to a file?

Question

I have an Android application that creates a SQLite DB and populates it with some data.

How do I save this database to a file so it can be shipped with another application?

score 2 · Answer 1 · answered Oct 03 '11 at 15:15

2

sqlite saves its data directly to a file. It's already done. The filename is specified in your connection string.

Are you trying to export to a different file type for some other software to read in?

answered Oct 03 '11 at 15:15

Tom Cerul

1,773
2
13
27

1

What I want is to have a pre populated db. So one app is run only once to read some data from a txt file and populate the db. Then I would put the db in assets folder of another app so it can read the data from there. So if it is saved to a file where is it saved so I can grab it a move somewhere else? – Radek Oct 03 '11 at 15:26
Take a look in the connection string where you connect to the sqlite database. It should have something like "Data Source=" + filename. That's the filename of the database. Just copy that file. – Tom Cerul Oct 03 '11 at 15:30
Where is the connection string? Sorry for stupid questions but I am new to android – Radek Oct 03 '11 at 15:54
Sorry, I don't know Android yet. Someone over here is talking about connecting... http://stackoverflow.com/questions/5001124/how-to-connect-an-sqlite-database-sqlite-firefox-extension-to-android-applicat It looks this is the part with the database name. He's got it stored in a variable DB_NAME in his example. public DbManager(Context context) { super(context, DB_NAME, null, DB_VERSION); this.context = context; – Tom Cerul Oct 03 '11 at 15:58

score 2 · Accepted Answer · answered Oct 03 '11 at 15:43

2

You can access the SQLite database file from the DDMS percpective of Eclipse when the device is connected, it is stored with your application's files in /data/data/package_name/databases.

There is a guide on how to find and replace a database by a preset file:

http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/

Or you can just create an SQL command dump, and make it execute on first launch is initialized - however it will be realy time consuming.

answered Oct 03 '11 at 15:43

Andras Balázs Lajtha

2,576
25
32

Yeah I tried to used ddms but when I click data folder it's empty – Radek Oct 03 '11 at 15:57
Accessing a SQLite database file via DDMS won't work on non-rooted devices. Best to use a SQL dump – Kilizo Mar 22 '13 at 22:59

score 0 · Answer 3 · edited May 23 '17 at 12:01

0

To export your SQLite data to a file, use the .dump command. See Exporting from SQLite to SQL Server

edited May 23 '17 at 12:01

Community

1
1

answered Oct 03 '11 at 15:16

Robert Martin

16,759
15
61
87

Save SQLite DB to a file?

3 Answers3

Linked