3 ms·
Or use SQLite and your backups are literally a copy of a file. You can abuse git for it if you really want to cut corners.
by ozozozd 1y ago
Or use SQLite and your backups are literally a copy of a file.
You can abuse git for it if you really want to cut corners.
- vanviegen 1y agoOnly if you can freeze your application for that long, in which case your statement is true for all non-broken databases.
- wild_egg 1y agoIt only freezes your application if you've misconfigured it.
- vanviegen 1y agoIf you want to backup your database using just a file copy, you'd better freeze your database if you value your data. Or use a fancy snapshotting filesystem.
- markusw 1y agoYou can easily do consistent backup on live databases. There’s a backup command and API.
- vanviegen 1y agoSure. But then it's not "just a file" copy, like GP said.