I’m trying to backup a room database programmatically.
For that, I’m simply copying the
.sqlite file that contains the whole database
But, before copying, due to the fact that room has write ahead logging enabled, we must close the database so that
-shm file and
-wal file merge into a single
.sqlite file. As pointed out here
Everything works fine with the backup, BUT, later on, when I try to execute an
INSERT query, I get this error:
android.database.sqlite.SQLiteException: no such table: room_table_modification_log (code 1)
How can I properly re-open room db after I close it?
RoomDatabase object returns