Comment by simonw
4 hours ago
That's fine if SQLite isn't running, but you risk corruption if you copy a file while it is being actively written to.
VACUUM INTO eliminates that risk.
4 hours ago
That's fine if SQLite isn't running, but you risk corruption if you copy a file while it is being actively written to.
VACUUM INTO eliminates that risk.
Thank you for mentioning this. I was planning to do exactly this soon and had no idea.