Partial backups enable backing up only specific databases or tables.
This enables you to take smaller backups which take less storage and is faster to restore.
It also allows you to recover only a specific database or table that might need to restore in case of a disaster.
The following backup methods are supported:
- mysqldump
- Allows you to filter by schema/database and/or exclude the tables you wanted to filter. Filtering a table has to be a
<database_name>.<table_name>format.
- Allows you to filter by schema/database and/or exclude the tables you wanted to filter. Filtering a table has to be a
- xtrabackup
- To create a partial backup, filter by schema/database and/or tables. You can either include/exclude a database or exclude/include tables. Selecting
Include Databaseswill disableInclude Tablesand allow you to onlyExclude Tables, but Exclude Databases allows both Include Tables and Exclude Tables to be specified but works mutually exclusive. Filtering a table has to be a<database_name>.<table_name>format. Same approach asmariabackup.
- To create a partial backup, filter by schema/database and/or tables. You can either include/exclude a database or exclude/include tables. Selecting
- mariabackup
- To create a partial backup, filter by schema/database and/or tables. You can either include/exclude a database or exclude/include tables. Selecting
Include Databaseswill disableInclude Tablesand allow you to only Exclude Tables, butExclude Databasesallows bothInclude TablesandExclude Tablesto be specified but works mutually exclusive. Filtering a table has to be a<database_name>.<table_name>format. Same approach asxtrabackup.
- To create a partial backup, filter by schema/database and/or tables. You can either include/exclude a database or exclude/include tables. Selecting
- pg_dumpall (
only available for PostgreSQL v12)- Allows you to selectively exclude database(s) for partial backup.
- pg_dump
- Allows you to specify the database (only one database at a time if specified). Requires that you specify a database if you have to either exclude a list of tables or include a list of tables.
- mongodump
- For partial backup, you can only specify a database once for filtering. Then you can specify the list of a table(s) you want to either exclude or include.