Syntax Error using Vacuum Into on Android

Asked Aug 24 '19 at 23:34

Active Aug 24 '19 at 23:34

Viewed 602 times

I'm trying to make a backup of a database in an Android application, and I was pointed to the VACUUM INTO query. However, when I try to call it, I get a syntax error around "INTO":

Caused by: android.database.sqlite.SQLiteException: near "INTO": syntax error (code 1 SQLITE_ERROR): , while compiling: VACUUM INTO 'Test'

The String itself:

String query = "VACUUM INTO 'Test'";

I've tried using double quotes, single quotes, different path names, .db, no file type, including and excluding the database name - always the same error.

Is INTO not supported on Android's implementation of SQLite?

asked Aug 24 '19 at 23:34

Shadow0144

`VACUUM INTO` was added in 3.27, which is new enough it's unlikely to be present on any Android version. – Shawn Aug 24 '19 at 23:54
Oh, I see. That's what I feared. Thank you. – Shadow0144 Aug 25 '19 at 00:33
Plus Android doesn't support the backup api that's been around forever. They don't make it easy. – Shawn Aug 25 '19 at 04:44

Syntax Error using Vacuum Into on Android

0 Answers0