Creates a backup for one, several, or all database tables.

:::tip

requires a backup directory which is set using the configuration key cairo.sql.backup.root in the file.

The backup directory can be on a local disk to the server, on a remote disk, or a remote filesystem. QuestDB will enforce that the backup are 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. By default, the format is , for example 2020-04-20.

:::tip

:::

The data and meta 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:

'backup directory/'
├── 2020-04-20.1    'second'
├── 2020-04-21      'first new date'
├── 2020-04-21.1    'first new date'