LogoLogo
EBR DocsHelp
Zmanda Pro
Zmanda Pro
  • Welcome to the Zmanda Pro Documentation
  • Overview and Concepts​
  • Best Practices
  • Start Here
    • Initial Security Setup
    • Step 1: Adding a User
    • Step 2: Client Download and Installation
    • Step 3: Client Login
    • Step 4: Adding a New Storage Vault
    • Step 5: Adding a New Protected Item
    • Step 6: Initiating a Backup
    • Step 7: Checking Backup Job Status
    • Step 8: Restore Data
  • Guide
    • Zmanda Pro Server Deployment (On-prem)
      • Zmanda Pro Self-Hosted Deployment
        • Self-Hosted Online Server
        • Self-Hosted Online Server Setup
        • Self-Hosted Offline Server
        • Self-Hosted Offline Server Setup
        • Storage Manager Service
        • Storage Manager Service Setup
        • Zmanda Pro Client Setup
        • Disaster Recovery Plan: Self-Hosted Server
        • Disaster Recovery Plan: Self-Hosted Server Recovery Workflow
        • Admin Password Reset
        • Custom Certificates Upload
    • Zmanda Pro Usage
    • Zmanda Pro Client Installation
      • Zmanda Pro user configuration
      • Storage configuration
    • Restarting at boot ​(Linux)
    • Protected Items
      • Files and Folders
      • MySQL
        • Xtrabackup
          • Configuration
          • Backup
          • Restore
          • Recover
        • MyDumper
          • Configuration
          • Backup
          • Restore
          • Recover
        • MySQLDump
          • Configuration
          • Backup
          • Restore
          • Recover
        • LVM
          • Configuration
          • Backup
          • Restore
          • Recover
        • Managing Data Directory Permissions with SELinux and AppArmor
        • Compatibility Matrix
      • MariaDB
        • MariaBackup
          • Configuration
          • Backup
          • Restore
          • Recover
        • MyDumper
          • Configuration
          • Backup
          • Restore
          • Recover
        • MariaDBDump
          • Configuration
          • Backup
          • Restore
          • Recover
        • LVM
          • Configuration
          • Backup
          • Restore
          • Recover
        • Managing Data Directory Permissions with SELinux and AppArmor
        • Compatibility Matrix
      • Microsoft Office 365
      • Postgres
      • Program Output
      • Microsoft Hyper-V
      • Microsoft SQL Server
      • MongoDB
      • Windows Server System State
      • Application-Aware Writer
      • Disk Image
      • VMware vSphere
        • Configuration
        • Backup
        • Restore
        • Troubleshooting
      • MariaDB
        • Backup & Restore MariaDB with a staging path
        • Backup & Restore MariaDB without a staging path using Streaming
      • Oracle RMAN
        • Configuration
        • Backup
        • Restore
        • Perform a Full Database Backup with Oracle RMAN
        • Perform a database backup using a Custom Oracle RMAN Script
        • Restore an Oracle RMAN backup using Backup Manager
        • Recover an Oracle database after restoring from Zmanda Pro Backup Manager
        • Troubleshooting Oracle RMAN backups with Backup Manager
    • Configure SSO
    • Configure & Apply Policies
    • Configure Email Reporting
    • Backup Manager
      • Login
    • Automation Tools
      • Bulk Operations with ZPAT
        • Bulk addition of policies
        • Bulk onboarding of devices
        • Bulk deletion of users
        • Bulk Rename of Devices
        • Bulk Restore
        • Bulk addition of protected items
        • Bulk administration of client devices with Ansible
      • Disaster Recovery Plan: Zmanda Pro Clients
    • Encryption & Key Management
    • Zmanda Pro Job Statuses
    • Disk Image Walkthrough
      • Create & Use Recovery Media
    • Common Problems & Solutions
    • Troubleshooting
    • VMware to Hyper-V Migration
      • Configuration
      • Backup
      • Restore to Hyper-V
Powered by GitBook
LogoLogo

Quick Links

  • Amanda Community Wiki
  • Amanda Community Downloads
  • Share Feedback

About

  • About Us
  • Customer Testimonials

Terms

  • Terms of Use
  • Privacy Policy

Contact Info

  • Denver, CO, USA
  • 888-496-2632 (US)
  • 408-732-3208 (INT)

2025 © Zmanda, A BETSOL Company

On this page
  • Configure the staging path
  • Configure Files & Folders Protected Item
  • Items Tab
  • Commands Tab
  • Save the Configuration
  • Restore & Recovery
  • Restore
  • Recovery

Was this helpful?

Export as PDF
  1. Guide
  2. Protected Items
  3. MariaDB

Backup & Restore MariaDB with a staging path

In this approach Mariabackup is used to write backups into a staging path, then the staging path is backed up using Zmanda Pro to the Storage Vault.

PreviousMariaDBNextBackup & Restore MariaDB without a staging path using Streaming

Last updated 7 months ago

Was this helpful?

Configure the staging path

  • Verify sufficient free space in the partition containing the staging path.

  • Remember to account for potential database growth.

mkdir /path/to/staging/area

Configure Files & Folders Protected Item

Items Tab

Include the path to the staging area configured and Click on Save

Commands Tab

Configure a Before Task to run mariabackup to the staging path

mariabackup --backup --extra-lsndir=/path/to/checkpoints/ --user=<backup-user>--password='<password>' --target-dir=/path/to/staging/area > /dev/null 2>&1

Configure an After Task to cleanup the staging path after the backup

rm -rf /path/to/staging/area

Save the Configuration

After saving the configuration you should see a Files and Folders protected item ready for your first backup.

You can configure schedules and retention periods similar to any other protected item.

Restore & Recovery

The Restore process involves retrieving the backed-up data from the backup storage (in this case, Zmanda Pro) and placing it in a specified location on the target system.

The Recovery process takes the restored data and prepares it for use by MariaDB. This involves several important steps to ensure data consistency and make it ready for the MariaDB server to use. This is a manual process

Restore

This process is similar to a Files and Folders restore.

  1. Navigate to the Devices Tab of the MariaDB server's Zmanda Pro user

  2. Click on the Actions and select Restore

  3. Select the appropriate Storage Vault to restore from

  4. Expand the Device name and Select the Protected Item name

  5. Make sure All items is selected for restore

  6. Select Restore as - Files and Folders

  7. Select Output directory to any path within the target system

  8. Click on Restore

Recovery

  1. Navigate to Output Directory

cd /path/to/output/directory
  1. Prepare the MariaDB target directory

mariabackup --prepare --target-dir=/path/to/output/directory
  1. Remove MariaDB data directory

  2. Recovering the restored files back

mariabackup --copy-back --datadir=/path/to/data/directory --target-dir=/path/to/output/directory
  1. Update the ownership of Data Directory to mysql

chown mysql:mysql /path/to/data/directory

Stop the MariaDB server
Start the MariaDB server
Configure mariabackup backup command as before task
Configure staging area clean up as after task
Run Backup for Mariabackup using Files and folders Protected Item