Version Migration

[C M Reinehr]

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 at 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
--------