Backup and restore SQLite database to sdcard

by

How can i backup my database to the
sdcard automatically in my app?

Copy it using standard Java I/O. Make sure you don’t have any open SQLiteDatabase objects, though.

And afterwards how do i restore it?

Copy it using standard Java I/O. Make sure you don’t have any open SQLiteDatabase objects to the old database, though.

You can use getPath() on a SQLiteDatabase object to find out where it resides, AFAIK (haven’t tried this).

More Related Contents:

  1. I am getting this error on my code [closed]
  2. Sqlite for Android
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  5. Best way to work with dates in Android SQLite [closed]
  6. How do I join two SQLite tables in my Android application?
  7. How can I create a user-defined function in SQLite?
  8. Android SQLite issue – table … has no column named
  9. Android error – close() was never explicitly called on database
  10. How do I create a database in android? [closed]
  11. What is a maximum size of SQLite database on Android?
  12. How to save images into Database
  13. Full text search example in Android
  14. Android SimpleCursorAdapter doesn’t update when database changes
  15. rawQuery(query, selectionArgs)
  16. How to implement Export sqlite To excel/csv file in android?
  17. How to store and retrieve a byte array (image data) to and from a SQLite database?
  18. SQLite Query in Android to count rows
  19. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  20. How does one check if a table exists in an Android SQLite database?
  21. Attempt to reopen an already-closed object sqlitedatabase
  22. how to save image taken from camera and show it to listview – crashes with “IllegalStateException”
  23. How insert image in room persistence library?
  24. How to view data saved in android database(SQLite)?
  25. How to store JSON object in SQLite database
  26. sqlite3: not found
  27. Android SQLiteOpenHelper cannot open database file
  28. Getting the type of a column in SQLite
  29. Android table creation Failure (near “autoincrement”: syntax error)?
  30. sqlite insert into table select * from

Leave a Comment