Veritas NetBackup™ for MySQL Administrator's Guide

Last Published:
Product(s): NetBackup (8.2)
Platform: Linux,UNIX,Windows

Post-installation requirements for NetBackup for MySQL Agent

After you install the agent

  • (Windows) Configure the NetBackup for MySQL Agent to run with administrative privileges.

  • (Windows) Add the NetBackup bin directory to the PATH user environment variable.

  • (Linux) If the nbmysql.conf file does not exist, create the default configuration file. For more information, See The nbmysql configuration file.

  • (Linux) The user of the agent is a superuser or have superuser privileges.

  • (Linux) Symbolic link: If a symbolic link does not exists, create a symbolic link libmysqlclient.so and ensure that it points to libmysqlclient.so.<n>, where n is the MySQL client library version . You can create the symbolic link at your chosen directory.

    For example, if the MySQL client library version is 18, then the symbolic link libmysqlclient.so points to libmysqlclient.so.18.

    Note:

    Ensure that you update the MYSQL_LIB_INSTALL_PATH parameter in the nbmysql.conf file with the absolute path of the symbolic link.

  • Set the following user privileges:

Table: User privileges

User

Privileges

Backup

LOCK TABLES, SELECT, FILE, RELOAD, SUPER, UPDATE, TRIGGER, SHOW, VIEW, EXECUTE, and EVENT.

Restore

CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, DELETE, UPDATE, TRIGGER, SUPER, and CREATE VIEW.

To set the user privileges, run the following commands:

GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, FILE, INDEX, ALTER, SUPER, LOCK TABLES, CREATE VIEW, SHOW VIEW, TRIGGER, CREATE ROUTINE, DELETE, EVENT, ALTER ROUTINE ON *.* TO 'USER'@'localhost' IDENTIFIED BY 'PASSWORD'

For more information, see MySQL Administration Guide