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.

Only if you can freeze your application for that long, in which case your statement is true for all non-broken databases.

markusw 4 days ago | parent | next [-]

You can easily do consistent backup on live databases. There’s a backup command and API.

	▲	vanviegen 4 days ago \| parent [-]
		Sure. But then it's not "just a file" copy, like GP said.

wild_egg 5 days ago | parent | prev [-]

It only freezes your application if you've misconfigured it.

	▲	vanviegen 4 days ago \| parent [-]
		If 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.