2016-04-14 22:07 GMT+02:00 Clemens Ladisch <clemens at ladisch.de>: > Cecil Westerhof wrote: > > what is the best way to make a backup? > > With the backup API: <http://www.sqlite.org/backup.html>. > (Also available as .backup in the shell.) >
?I should be more precise in my communication. :'-( I prefer to make my backup with .dump. Then I have just a text based backup. This works fine for the regular data, but not for photos: they can be 13 MB big. (And I am not even using raw. When I am going to do that, they will become much bigger.) So I would like to have my photos split out when making the dump. But maybe it will be better to use external blobs. Something to think about. -- Cecil Westerhof