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 file is located in the following locations:
(Windows)
install_path\NBMySQLAgent_8.2_AMD64\nbmysql.conf.(Linux (RHEL)
install_path/NBMySQLAgent_8.2_linuxR_x86/nbmysql.conf.(Linux SUSE)
install_path/NBMySQLAgent_8.2_linuxS_x86/nbmysql.conf.
Starting from NetBackup 8.2, the nbmysql.conf file is not created by default when you install the agent on RHEL or SUSE. The existing configuration file is prevented from getting overwritten as the RPM installer simply overwrites any existing files in the destination directory /usr/NBMySQLAgent/.
If the nbmysql.conf file does not exist, you can create the file by running the backup utility command without any options. For example, run the ./nbmysql command. This command creates the default nbmysql.conf file.
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. |
NETBACKUP_MASTER_SERVER | Specifies the NetBackup master server to run backups and restores. | Backup operations | No default value for this parameter. |
NETBACKUP_POLICY_NAME | Specifies the NetBackup DataStore policy name. | Backup operations | No default value for this parameter. |
NETBACKUP_SCHEDULE_NAME | Identifies the backup schedule that you configured while creating the DataStore policy. | Backup operations | No default value for this parameter. |
NETBACKUP_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. |
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 |