mariadb-backup

Get an overview of MariaDB Backup. This section introduces the hot physical backup tool, explaining its capabilities for efficient and consistent backups of your MariaDB Server.

mariadb-backup Overview

An introduction to the mariadb-backup utility, detailing its features, installation process, and support for hot online backups of InnoDB tables.

mariadb-backup Options

A comprehensive reference for all command-line options available in mariadb-backup, covering backup, prepare, and restore operations.

Full Backup and Restore (mariadb-backup)

Learn how to perform and restore full physical backups of MariaDB databases using the mariadb-backup tool, ensuring consistent data recovery.

Incremental Backup and Restore (mariadb-backup)

This guide explains how to create and apply incremental backups with mariadb-backup, saving storage space and reducing backup time.

Point-In-Time Recovery (PITR, mariadb-backup)

Explains how to restore (recover) to a specific point in time. Point-in-time recovery is often referred to as PITR.

Partial Backup and Restore (mariadb-backup)

Back up specific databases or tables. This guide explains how to filter your backup to include only the data you need.

Restoring Individual Databases From a Full Backup (mariadb-backup)

Restore a single database from a full backup. Learn the procedure to extract and recover a specific database schema from a larger backup set.

Restoring Individual Tables and Partitions (mariadb-backup)

Restore specific tables from a backup. Learn the process of importing individual .ibd files to recover specific tables without restoring the whole database.

Setting up a Replica (mariadb-backup)

Initialize a replication slave using a backup. This guide shows how to use mariadb-backup to provision a new replica from a master server.

Files Backed Up by mariadb-backup

List of file types included in a backup. Understand which data files, logs, and configuration files are preserved during the backup process.

Files Created by mariadb-backup

Reference of files generated during backup. This page explains the purpose of metadata files created by the mariadb-backup.

Using Encryption and Compression Tools With mariadb-backup

Secure and compress backup streams. Learn to pipe backup output to tools like GPG and GZIP for encryption and storage efficiency.

How mariadb-backup Works

Deep dive into backup mechanics. Understand how the tool handles redo logs, locking, and file copying to ensure consistent backups.

mariadb-backup and BACKUP STAGE

Understand backup locking stages. This page explains how mariadb-backup uses BACKUP STAGE statements to minimize locking during operation.

mariadb-backup SST Method

Configure State Snapshot Transfers for Galera Cluster. Learn to use mariadb-backup for non-blocking data transfer when a new node joins a cluster.

Manual SST of Galera Cluster Node With mariadb-backup

Perform a manual node provision. This guide details the steps to manually backup a donor and restore it to a joiner node in a Galera Cluster.