Safely copy a SQLite database
It’s trivially easy to copy a SQLite database. It’s less trivial to do this in a way that won’t corrupt it. Here’s how:
$ sqlite3 some.db
sqlite> begin immediate;
<press CTRL+Z>
$ cp some.db some.db.backup
$ exit
sqlite> rollback;
This will give you a nice clean backup that’s sure to be in a proper state, since writing to the database half-way through your copying process is impossible.
Thanks to Habbie for this info!