How to merge contents of SQLite 3.7 WAL file into main database file
From the command line, do this:
sqlite3 MyDatabase.sqlite
VACUUM;
- CTRL-D to exit the sqlite console.
Done!
The -wal file should now have a size of 0 and everything should be in your main database file.
Do a checkpoint, i.e., execute PRAGMA wal_checkpoint.