Hello.

I have an application using an internal SQLite database.
Now I want to replace it with a database file stored on the SDCard.

After copying the file using standard input/output methods I tried to open a connection, but got an exception that table xyz already exists, so it looks like my SQLiteOpenHelper rerun OnCreate even though the database was already present.
The database was an exact copy of a database created by the helper, I just pulled it down, added a few dummy entries and pushed it back to the SDCard where I used my import method to copy it to my package/database directory.
What am I missing? How do I correctly overwrite an existing database with an external one without selecting and inserting row by row?



Also, how do I export an internal database to the SDCard? I tried the normal IO methods, but it looks like I don't have write access to /sdcard/.
I used

but it always returns false.
Is there any way to get write permission for the SDCard?
The SDCard is present and mounted, I can read files just fine.


Thank you.

you need write permissions in android manifest to write to SD card.

I have a tutorial on how to embed a database in an application on my blog here :
http://androidblogger.blogspot.com/2009/05/how-to-ship-application-with-pre-baked.html

But at the time of the writing, there was no write permission for the SD card !

But at the time of the writing, there was no write permission for the SD card !

You need this when using 1.6 as target

Hi, thanks for your answers.

padde wrote:you need write permissions in android manifest to write to SD card.

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using xml Syntax Highlighting

1. <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"></uses-permission>
2.  

Parsed in 0.000 seconds, using GeSHi 1.0.8.4

Ouch, I actually had this in the android:permission tag in my application tag but not in uses-permission, thanks for that.


I could solve the import issue by adding the IF NOT EXISTS clause when creating the tables in onCreate in my SQLiteOpenHelper, shame on me for not having thought of that earlier.


Everything is working fine now, thanks.