# mariadb-backup

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/mariadb-backup-overview" %}
[mariadb-backup-overview](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-overview)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
An introduction to the `mariadb-backup` utility, detailing its features, installation process, and support for hot online backups of InnoDB tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/mariadb-backup-options" %}
[mariadb-backup-options](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/full-backup-and-restore-with-mariadb-backup" %}
[full-backup-and-restore-with-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/full-backup-and-restore-with-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/incremental-backup-and-restore-with-mariadb-backup" %}
[incremental-backup-and-restore-with-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/incremental-backup-and-restore-with-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/point-in-time-recovery-pitr-mariadb-backup" %}
[point-in-time-recovery-pitr-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/point-in-time-recovery-pitr-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains how to restore (recover) to a specific point in time. Point-in-time recovery is often referred to as PITR.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/partial-backup-and-restore-with-mariadb-backup" %}
[partial-backup-and-restore-with-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/partial-backup-and-restore-with-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/individual-database-restores-with-mariadb-backup-from-full-backup" %}
[individual-database-restores-with-mariadb-backup-from-full-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/individual-database-restores-with-mariadb-backup-from-full-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/restoring-individual-tables-and-partitions-with-mariadb-backup" %}
[restoring-individual-tables-and-partitions-with-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/restoring-individual-tables-and-partitions-with-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/setting-up-a-replica-with-mariadb-backup" %}
[setting-up-a-replica-with-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/setting-up-a-replica-with-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/files-backed-up-by-mariadb-backup" %}
[files-backed-up-by-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-backed-up-by-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/files-created-by-mariadb-backup" %}
[files-created-by-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-created-by-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of files generated during backup. This page explains the purpose of metadata files created by the `mariadb-backup`.

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/using-encryption-and-compression-tools-with-mariadb-backup" %}
[using-encryption-and-compression-tools-with-mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/using-encryption-and-compression-tools-with-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/how-mariadb-backup-works" %}
[how-mariadb-backup-works](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/how-mariadb-backup-works)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="mariadb-backup/mariadb-backup-and-backup-stage-commands" %}
[mariadb-backup-and-backup-stage-commands](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-and-backup-stage-commands)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand backup locking stages. This page explains how mariadb-backup uses `BACKUP STAGE` statements to minimize locking during operation.

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="<https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/high-availability/state-snapshot-transfers-ssts-in-galera-cluster/mariadb-backup-sst-method>" %}
[mariadb-backup SST Method](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/high-availability/state-snapshot-transfers-ssts-in-galera-cluster/mariadb-backup-sst-method)
{% endcontent-ref %}
{% endcolumn %}

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

<br>
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="<https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/high-availability/state-snapshot-transfers-ssts-in-galera-cluster/manual-sst-of-galera-cluster-node-with-mariadb-backup>" %}
[Manual SST of Galera Cluster Node With mariadb-backup](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/high-availability/state-snapshot-transfers-ssts-in-galera-cluster/manual-sst-of-galera-cluster-node-with-mariadb-backup)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.

<br>
{% endcolumn %}
{% endcolumns %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.