dump command to dump some tables

[Harry van der Wolf]

Hi,

I have an application with underlying SQLite DB. The DB mainly consists of "info/reference"  data but also some user data.

I want to give the users the option to backup/restore their user data, but that is currently only in a few tables.

I don't want to backup the full database as my application also contains an update method, making alterations upon a new version (when necessary).

How do I dump/backup only a few tables including schema (create table ..., followed by insert into ..)

Harry