Comment by cenamus

Alternatively look at https://sqlite.org/backup.html for backing up the sqlite db, instead of using VACUUM INTO