Oct 17, 2025 Replies: 2 B4X: Copy SQL.ExecNonQuery("BACKUP TO " & BackupPath) I tried online backup API using .backup but it doesn't work. I searched for jdbc method and the above command works even the database is in used. This method doesn't vacuum the database. I think RESTORE FROM should also work. Click to expand...
B4X: Copy SQL.ExecNonQuery("BACKUP TO " & BackupPath) I tried online backup API using .backup but it doesn't work. I searched for jdbc method and the above command works even the database is in used. This method doesn't vacuum the database. I think RESTORE FROM should also work.
Magma Expert Licensed User Longtime User Oct 18, 2025 #2 Hi there ... i think that this vacuum too.. https://www.b4x.com/android/forum/threads/backup-sqlite-db-with-vacuum-into.145313/
Hi there ... i think that this vacuum too.. https://www.b4x.com/android/forum/threads/backup-sqlite-db-with-vacuum-into.145313/
aeric Expert Licensed User Longtime User Oct 18, 2025 #3 Magma said: Hi there ... i think that this vacuum too.. https://www.b4x.com/android/forum/threads/backup-sqlite-db-with-vacuum-into.145313/ Click to expand... Yes, I have seen that tutorial. But the snippet above does not vacuum if someone chooses not to. The alternative to this snippet is vacuum. There may be a case you want to use either one.
Magma said: Hi there ... i think that this vacuum too.. https://www.b4x.com/android/forum/threads/backup-sqlite-db-with-vacuum-into.145313/ Click to expand... Yes, I have seen that tutorial. But the snippet above does not vacuum if someone chooses not to. The alternative to this snippet is vacuum. There may be a case you want to use either one.
