mariadb-backup
mariadb.com
- Free plan
- Windows
- Linux
- Self-hosted
What mariadb-backup is
mariadb-backup is a free, open-source utility for physical backups of MariaDB data. It supports full, incremental, and partial backups, point-in-time recovery, and restoration of individual databases, tables, and partitions. It works with InnoDB, Aria, MyISAM, and MyRocks. For InnoDB, it can make hot online backups, and full backups on running systems use a nearly non-blocking method. It can also transfer Galera Cluster state snapshots. Tables protected by Data-at-Rest Encryption can be backed up while remaining encrypted; the tool can load the server's key management and encryption plugin. Backup output can be streamed to stdout and piped to tools such as OpenSSL or gzip, and InnoDB page-compressed tables are supported. Before restoring, backups must be prepared with the --prepare option so the data files are consistent for use. Safe full and incremental restores require an empty MariaDB data directory. Backup operations connect to the running server and generally require specific global privileges; restore operations do not require a database user.
Who it suits
It suits MariaDB administrators who need physical backups and recovery options across supported storage engines. It is available for Linux and Windows and is self-hosted.
Good to know, and what to watch
- Supports full, incremental, and partial backups.
- Offers point-in-time recovery and selected-object restoration.
- Can make hot online InnoDB backups.
- Supports encrypted and InnoDB page-compressed tables.
- Backup output can be streamed to other tools.
- Partial backups cannot restore directly onto servers containing other data.
- Backups must be prepared before restoration.
- Safe full and incremental restores require an empty data directory.
- Backup operations generally need specific global privileges.
Plans
Every plan and priceOpen-source mariadb-backup
Free plan
The verdict
mariadb-backup covers several backup types and restoration scenarios, including online InnoDB backups. Account for preparation, privilege, and empty-directory requirements when planning restores.
What the maker publishes
- Backup access
- For backup operations, the tool connects to the running server and MariaDB recommends using a dedicated user with backup privileges; restore operations do not require a database user. source
- Backup modes
- It supports full, incremental, and partial backups, as well as point-in-time recovery. source
- Backup preparation
- A backup must be prepared before restoring it so its files are made consistent for use by MariaDB Server. source
- Backup types
- It supports full, incremental, and partial backups, plus point-in-time recovery and restoration of individual databases, tables, and partitions. source
- Compression
- It supports backing up and restoring tables that use InnoDB page compression. source
- Encryption
- It supports backing up and restoring tables using data-at-rest encryption, and encrypted tables remain encrypted in the backup. source
- Encryption support
- It supports tables using Data-at-Rest Encryption and can load the server's key management and encryption plugin to back up encrypted tables. source
- Galera integration
- It can be used for Galera Cluster state snapshot transfers (SSTs). source
- Headquarters
- Silicon Valley and Ireland source
- Online backups
- It can make hot online InnoDB backups and provides a nearly non-blocking method for full backups on running systems. source
- Online operation
- It provides a nearly non-blocking method for full backups on running systems, with hot online backups available for InnoDB. source
- Operational requirements
- For backup operations, the database account generally needs the global RELOAD, PROCESS, LOCK TABLES, and BINLOG MONITOR privileges. source
- Partial backup limitation
- Partial backups require many steps and cannot be restored directly onto existing servers containing other data. source
- Platforms
- The utility is available on Linux and Windows. source
- Purpose
- mariadb-backup is an open source tool for physical online backups of MariaDB tables. source
- Restore preparation
- Backups must be prepared with the --prepare option before restoration so the data files become point-in-time consistent. source
- Restore requirement
- For safe full and incremental restoration, the MariaDB data directory must be empty. source
- Storage engines
- It supports InnoDB, Aria, and MyISAM tables, and also supports MyRocks backups and restores. source
- Stream integrations
- It can stream backup output to stdout, allowing it to be piped to tools such as OpenSSL and gzip for encryption or compression. source
Checked against the maker's pages on 7 Oct 2026.