Creating backup of specific tables

[bhushanvadgave]

Requirement

In our rqlite database, we maintain 2 kinds of tables - 1. System/Internal tables and 2. User tables. System tables are used for maintaining the data related to the system's internal workflows. As part of the backup process, which is automated, we would like to backup or create a dump of only User tables.

Solution expected

Sqlite's .dump command supports the creation of SQL dumps for specific tables by accepting table names as input. Similarly, Rqlite can support this by accepting table names in curl -s -XGET localhost:4001/db/backup?fmt=sql -o bak.sql API.

[otoolep]

Sounds like a reasonable request. I can look into after I ship 8.0, which I need to focus on for now.

[bhushanvadgave]

Sure. Thanks.