java - SQLite backup & restore strategy -

java - SQLite backup & restore strategy -

i new sqlite. long beingness used oracle / sql maintained centrally dba manages these

i planning utilize sqlite db in 1 of our java/jsp application.

the info written , read db

i store sqlite db file in same server application itself. there possibility db file getting deleted (for ever reasons)

i wondering backup , restore strategy apply here in order backup db incrementally , restore in worst case.

simply copying file (batch file re-create file 1 location another) every , won't work db file may used

how big files talking about?

the locking issue perchance solved using llvm snapshot described here: http://tldp.org/howto/lvm-howto/snapshots_backup.html

with normal databases, mariadb can this:

flush info , lock writes take llvm snapshot release locks mount snapshot somewhere , create backup tar, rsync, tarsnap, etc

then again, usable need lock sqlite db file somehow when creating snapshot.

java sqlite jsp