Veritas NetBackup™ for MariaDB Administrator's Guide

Last Published:
Product(s): NetBackup (8.1.2)

About restoring MariaDB backups

The nbmariadb -o restore command for restore initiates the restore operation using -S, -t, and portnum as the required parameters. The parameters -id and -C are optional parameters.

The parameter -id restores the backup using the specified backup image name. The parameter -C lists all the backups that exists on the specified client. When you do not specify the client, it defaults to NetBackup master server.

Note:

Ensure that the MariaDB agent and NetBackup are of same version for successful backup and restore operations.

Figure: NetBackup for MariaDB restore workflow

NetBackup for MariaDB restore workflow
The NetBackup for MariaDB restore workflow

When you initiate a restore, the agent reads the command line arguments and parses the nbmariadb.conf configuration file. The agent then interacts with the NetBackup XBSA interface to retrieve the backup according to the specified parameters.

The NetBackup XBSA interface reads the progress files to receive the MariaDB backup files to restore them to the target directory.

The command prompt indicates the successful completion status of the restore. The Activity Monitor also displays the status for the restore job.

Prerequisites

Before you run a restore, you must meet the following prerequisites:

  • Ensure that versions of the MariaDB agent and NetBackup are same. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.

  • (LVM users) Ensure that data logs and the logs directory reside on logical volumes

  • Ensure that you restore the MariaDB instance to a valid empty target directory.

  • (non-LVM) Ensure that the MariaDB service is running.

  • Set the following parameters in the nbmariadb.conf file:

    • CLIENT_NAME

    • DB_BACKUP_ID

    • (Linux) DB_PORT

    • MARIADB_TARGET_DIRECTORY

    • MASTER_SERVER_NAME