NetBackup™ for MySQL Administrator's Guide

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

Performing the MySQL backups

This topic lists the prerequisites, describes the procedure to run MySQL backups, and the information to schedule the backup from the NetBackup Administration Console.

Prerequisites

Before you run the backup, ensure that you meet the following prerequisites.

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

  • (LVM users) Ensure that the MySQL data and logs directory reside on a single logical volume.

  • Configure the DataStore policy from the NetBackup Administration Console.

  • Add the database parameters and library path in the nbmysql.conf file.

  • Verify that there is enough space for the snapshot in the volume group, and then set the snapshot size in nbmysql.conf file or by the command line.

    Note:

    Ensure that the sufficient free size is available for snapshot.

  • Verify that the prerequisites and the post-installation requirements are met.

    For more information,

    For more information, See Post-installation requirements for NetBackup .

To run backup

  1. Run the following command:
    nbmysql -o backup 
-S primary_server_name 
-P policy_name 
-s schedule_name 
-l mysql_lib_path 
(Linux) -z snapshot_size 
[-p database_server_port] 
[-u database_username]
(Linux) [-b backup_type]
  2. (Optional) Type the password, when the nbmysql command line prompts for the password.

Note:

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

Scheduling MySQL backups from NetBackup

You can schedule MySQL backups from NetBackup Administration Console using the DataStore policy to call a backup script.

For more information, https://www.veritas.com/support/en_US/article.100041374