Creates a backup for one, several, or all database tables.
Backing up a database or tables requires a backup directory which is set
configuration key in a
The backup directory can be on a disk local to the server, a remote disk or
a remote filesystem. QuestDB will enforce that the backup is only written in a
location relative to the
backup directory. This is a security feature to
disallow random file access by QuestDB.
The tables will be written in a directory with today's date with the default
2020-04-20). A custom date format can be specified
BACKUP query run on
2021-02-25, the data and metadata files will be
written following the
db directory structure
If a user performs several backups on the same date, each backup will be written a new directory. Subsequent backups on the same date will look as follows: