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 .
Before you run the backup, ensure that you meet the following prerequisites.
Ensure that versions of the MySQL agent and NetBackup are same. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.
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 .
Add the database parameters and library path in the
nbmysql.conffile.Verify that there is enough space for the snapshot in the volume group, and then set the snapshot size in
nbmysql.conffile or by the command line.Note:
Ensure that sufficient free size is available for the snapshot.
Verify that the prerequisites and the post-installation requirements are met.
For more information, See Installing prerequisites of NetBackup for MySQL Agent.
For more information, See Post-installation requirements for NetBackup for MySQL Agent .
To run backup
- Run the following command:
nbmysql -o backup -S master_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]
- (Optional) Type the password, when the nbmysql command line prompts for the password.
Note:
Ensure that the MySQL agent and NetBackup are of same version for successful backup and restore operations.
You can schedule MySQL backups from NetBackup Administration Console using the policy to call a backup script.
For more information, https://www.veritas.com/support/en_US/article.100041374