# Backup & Restore - [Backup and Restore Overview](https://mariadb.com/docs/server/server-usage/backup-and-restore/backup-and-restore-overview.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariabackup usage, scheduling, and restoration for production use. - [Forming a Backup Strategy](https://mariadb.com/docs/server/server-usage/backup-and-restore/forming-a-backup-strategy.md): Learn how to design a robust backup strategy tailored to your business needs, balancing recovery time objectives and data retention policies. - [Backup Optimization](https://mariadb.com/docs/server/server-usage/backup-and-restore/backup-optimization.md): Discover techniques to optimize your backup processes, including multithreading, incremental backups, and leveraging storage snapshots. - [MariaDB Enterprise Backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md): This page details MariaDB Enterprise Backup, an enhanced version of mariadb-backup with enterprise-specific optimizations and support. - [mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup.md): 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](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-overview.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariadb-backup usage, scheduling, and restoration for production use. - [mariadb-backup Options](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options.md): Reference for mariadb-backup (mariabackup) command-line options. Covers --backup, --prepare, --copy-back, --move-back, streaming, and incremental backups. - [Full Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/full-backup-and-restore-with-mariadb-backup.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariabackup usage, scheduling, and restoration for production use. - [Incremental Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/incremental-backup-and-restore-with-mariadb-backup.md): Complete mariadb-backup incremental guide: --backup/--prepare syntax, LSN xtrabackup\_checkpoints, --incremental-basedir, and --copy-back/--move-back restore. - [Partial Backup and Restore (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/partial-backup-and-restore-with-mariadb-backup.md): Back up specific databases or tables. This guide explains how to filter your backup to include only the data you need. - [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.md): Explains how to restore (recover) to a specific point in time. Point-in-time recovery is often referred to as PITR. - [Restoring Individual Databases From a Full Backup (mariadb-backup)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/individual-database-restores-with-mariadb-backup-from-full-backup.md): 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)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/restoring-individual-tables-and-partitions-with-mariadb-backup.md): 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)](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/setting-up-a-replica-with-mariadb-backup.md): 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](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-backed-up-by-mariadb-backup.md): 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](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/files-created-by-mariadb-backup.md): Reference of files generated during backup. This page explains the purpose of metadata files like xtrabackup\_checkpoints created by the tool. - [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.md): 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](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/how-mariadb-backup-works.md): 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](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-and-backup-stage-commands.md): Understand backup locking stages. This page explains how mariadb-backup uses BACKUP STAGE statements to minimize locking during operation. - [Replication as a Backup Solution](https://mariadb.com/docs/server/server-usage/backup-and-restore/replication-as-a-backup-solution.md): Explore how to use replication as part of your backup strategy, allowing you to offload backup tasks to a replica server to reduce load on the primary. - [Backup and Restore via dbForge Studio](https://mariadb.com/docs/server/server-usage/backup-and-restore/backup-and-restore-via-dbforge-studio.md): Learn how to use dbForge Studio, a GUI tool, to perform backup and restore operations for MariaDB databases visually. --- # 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.md?ask= ``` 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.