MariaDB Backup and Restore

Ahsay brings you specialized client backup software, namely AhsayOBM, to provide a set of tools to protect your MariaDB Database Server.

We recommend you read first the Overview section (GUI & CLI). This will help you become familiar with the different functions, settings and features that can be configured in AhsayOBM. It will also be helpful to know the different features that can be customized in the backup set before creating one.

This guide will only focus on:

  • How to create a MariaDB backup set
  • How to run a backup job
  • How to recover and restore MariaDB data using automatic and manual restore.

Run on Client (Agent-based) Backup

Below is the system architecture diagram illustrating the major elements involved in the backup and restore process among the MariaDB Database Server, AhsayOBM, and AhsayCBS.

success

Database Backup Process

To better help you understand what goes on during a backup process, here are the steps performed during a backup job.

The following steps are performed during a MySQL Database backup job. For an overview of the detailed process for Steps 3, 5, 11, and 13, please refer to the File Backup and Restore section (GUI & CLI).

  • Periodic Data Integrity Check (PDIC) Process (Step 3)
  • Backup Set Index Handling Process
    • Start Backup Job (Step 5)
    • Completed Backup Job (Step 13)
  • Data Validation Check Process (Step 11)

success

MariaDB Database Backup Method

AhsayOBM MariaDB Database backup uses a spooling method to make a consistent snapshot of the database(s) for backup.

For each database backup job AhsayOBM will trigger MariaDB to spool or make a copy of the database (.sql) file to the temporary folder using the mysqldump utility.

Windows

success

Linux

success

Mysqldump Parameters

Here is the mysqldump parameter list used for generating the spooled dump file:

  • --databases
  • --password
  • --result-file
  • --port
  • --user
  • --host
  • --opt
  • --quote-names
  • --allow-keywords
  • --triggers

Example:

For the spooling of the “nation” database to a %folder_path% the following parameters will be used:

Mysqldump --databases nation --user=user1 --password=qwerty --host=localhost --port=3306 - -opt --quote-names --allow-keywords --triggers --result-file=%folder_path%\nation.sql

For details on mysqldump parameters, please refer to:

Mysqldump - A Database Backup Program

AhsayOBM