How to commit changes to commhistory.db since -wal file exists?
asked 2019-07-02 14:18:46 +0200
I wanna edit sms db (sqlite3 $HOME/.local/share/commhistory/commhistory.db) But since there's -wal file there that keeps changes, my edits to .db aren't displayed in SMS app. I tried to do VACUUM and make a wal checkpoint, still nothing.
Currently my .db file is 4mb and -wal file is 6mb. How can I commit -wal file changes to .db and make it see my supplied changes to .db?
PS Restarts don't help.