NetBackup™ for MySQL Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.1)

Performing the restores for MySQL databases

This topic lists the prerequisites and describes the procedure to restore the backups.

Prerequisites

Before you restore the backups, you must meet the following prerequisites:

  • Ensure that the user has administrator (Windows) or root (Linux) access.

  • Ensure that you restore the MySQL instance to an empty target directory.

  • Ensure that the target directory is a valid instance directory.

  • (Non-LVM) Ensure the MySQL services are running.

To restore the backups

  1. Configure the parameters using the nbmysql command.

    For more information,

  2. Verify that the MySQL services are running for Non-LVM restores.
  3. Run the following command:

    nbmysql -o restore -S primary_server_name -t target_directory -p db_port [-i copy_id] [-C client_name] [-u db_user] [-H db_host]