Hi List,
I was wondering if there was a good way of backing up an SQLite database if you do *not* have access to the SQLite command line tool (which I know has .backup - https://stackoverflow.com/a/25684912).

The new VACUUM INTO (https://www.sqlite.org/lang_vacuum.html#vacuuminto) is not an option either because I'm using this via PHP on a remote host I have no control over, and its version of SQLite will definitely be older than 3.27.0.

I've considered simply running "PRAGMA wal_checkpointer;" and then copying the file immediately after that, but that still seems prone to error.

Any suggestions?


sqlite-users mailing list

Reply via email to