Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

mariadb-backup

mariadb.com

  • Free plan
  • Windows
  • Linux
  • Self-hosted
7.3 Club score Visit mariadb.com

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.

Open-source mariadb-backup

Free

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.