3 ms·
It isn't safe to copy a SQLite database because the file might be in the middle of a transaction. You need to use the ".backup" command instead.
by andai 5y ago
It isn't safe to copy a SQLite database because the file might be in the middle of a transaction. You need to use the ".backup" command instead.
- Neil44 5y agoThis is true, but because most Wordpress sites hardly ever do inserts etc it’s probably not going to be an issue in this scenario.
- billpg 5y agoIf that's true, that's a flaw in SQLite. The plug might be pulled at any moment and you can't stop it.
- billpg 4y agoI am incorrect in this regard.
- axelthegerman 4y agoYou can use litestream for proper sqlite replication