There may be other ways to backup the database, but there is a built-in
.dump command which will "dump" the entire contents data & schema into
an SQL formatted, text file. This file can then be read back by sqlite
to replicate the entire database.
Since an sqlite database is just a single file, that file can be backed
up any way that you would back up any other file.
Cheers!
CMR
On 08/31/2017 04:36 PM, Mike or Penny Novack wrote:
I'm accomplishing that part by writing the sqlite3 file to Dropbox,
which etc. etc. (other discussion of backups)
I have no familiarity with "small" version implementations of SQL <<
in my working days, it was mainframe SQL under the DB2 database manger >>
Are folks saying that sqlite3 does NOT come with a backup/restore
utility? I would think that at least somewhat strange.
Michael D Novack
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
--
"By failing to prepare, you are preparing to fail." -- Benjamin Franklin
--------
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
