sqlite3 .dump forgets user_version: test your restore

sqlite3 .dump forgets user_version: test your restore If your SQLite app reads PRAGMA user_version to decide which migrations to run, and your backup is a sqlite3 .dump, a restore can bring back every row and still be refused. The dump never writes user_version or application_id, so the restored file reads 0 for both. One extra argument on the... Weiterlesen: sqlite3 .dump forgets user_version: test your restore