Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


This is true, but because most Wordpress sites hardly ever do inserts etc it’s probably not going to be an issue in this scenario.


If that's true, that's a flaw in SQLite. The plug might be pulled at any moment and you can't stop it.


I am incorrect in this regard.


You can use litestream for proper sqlite replication




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: