NetBackup™ for MySQL Administrator's Guide
- Introduction to NetBackup for MySQL Agent
- Installing NetBackup for MySQL Agent
- Planning the installation of NetBackup for MySQL Agent
- Verifying the operating systems and the platforms
- Installing prerequisites of NetBackup for MySQL Agent
- Post-installation requirements for NetBackup for MySQL Agent
- Describing the NetBackup for MySQL Agent package
- Installing the NetBackup for MySQL Agent
- Authenticating the password
- Uninstalling the NetBackup for MySQL Agent
- Configuring NetBackup for MySQL Agent
- NetBackup for MySQL backup and restore
- Troubleshooting for NetBackup for MySQL
- Appendix A. The NetBackup for MySQL commands and conventions
- Appendix B. The NetBackup for MySQL commands
- Index
The nbmysql configuration file
The configuration file (nbmysql.conf) contains the parameters for the respective operations. It contains predefined settings and is located on the client. You can configure the parameters in the nbmysql.conf file or provide them on the command line, where the command line parameters take precedence. The nbmysql.conf file keeps you from providing the parameters every time you run operations. When parameters are not configured in the nbmysql.conf file, then the default parameter value takes precedence.
The nbmysql.conf is created when the backup operation is performed.
Table: The nbmysql.conf parameters lists the nbmysql.conf parameters.
Table: The nbmysql.conf parameters
Parameters | Description | Required parameter for | Default value |
|---|---|---|---|
DB_USER | Configures the MySQL database user name. | Backup and restore operations. | When you do not set the database user name, it defaults to root. |
DB_PORT | Configures the MySQL database server port number on which the backup or the restore has to be performed. | Restore operations | When you do not set the database server port, it defaults to 3306. |
DB_HOST | Configures the MySQL database hostname. | Non-LVM restore operations | No default value for this parameter. This parameter must be specified. |
MYSQL_LIB_INSTALL_PATH | Configures the On Linux, run the libmysqlclient command to locate the library path. | Backup operations | No default value for this parameter. |
MASTER_SERVER | Specifies the NetBackup master server to run backups and restores. | Backup operations | No default value for this parameter. |
POLICY_NAME | Specifies the NetBackup DataStore policy name. | Backup operations | No default value for this parameter. |
SCHEDULE_NAME | Identifies the backup schedule that you configured while creating the DataStore policy. | Backup operations | No default value for this parameter. |
CLIENT_NAME | Defines the NetBackup MySQL client name. | Redirected restores and query backups. | When you do not set the NetBackup client, it defaults to the NetBackup master server. |
SNAPSHOT_SIZE | (Linux) Specifies the snapshot size in kilobytes, megabytes, or gigabytes as K, M, or G respectively. | LVM backups | When you do not set the snapshot size, it defaults to |
COPY_ID | Represents the backup image name. You can use this value to query, restore, or delete a specific backup. | To query, restore, or delete a backup using its backup image name. | No default value for this parameter. |
MYSQL_TARGET_DIRECTORY | Specifies the destination directory where you want to restore the backups. | Restore backups. | No default value for this parameter. |
MYSQL_INSTALL_DIRECTORY | Specifies the directory where your MySQL instance is installed | Backup from the provided directory. | No default value for this parameter. |
NBMYSQL_LOG_LEVEL | The NBMYSQL_LOG_LEVEL lets you set the logging level for the NetBackup MySQL logs. The default value is 1. For a particular logging level, all details at that level or lower are logged. The MySQL debug logs includes the following verbose levels:
| The log levels help to control the amount of information that you want to access, when troubleshooting errors. | When you do not set |
NBMYSQL_LOG_SIZE | Configures the | You can specify the value according to the events that you want to write into the logs. | When you do not specify the
|
BACKUP_TYPE | Available options:
| Backup operations |
|