If you're trying to copy a file while connections still have it open
then you should use SQLite API calls to do it. The obvious ones are
in the SQLite Online Backup API, which is the set of calls underlying
the '.backup' command you mentioned. You can find documentation for
this here:
<https://www.sqlite.org/backup.html>
Unfortunately I don't think the PHP sqlite3 tools give access to this
API.
Not yet, but I did a patch and there is a pending pull request for that:
https://github.com/php/php-src/pull/3617
It does work, I'm using it, and you could too if you are willing to
compile your own PHP extension.
Hopefully it will land in PHP 7.4 :)
Cheers.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
