NetBackup™ for MySQL Administrator's Guide

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

Post-installation requirements for NetBackup

After you install the agent

  • (Windows) Ensure that the user who is performing backups and restores has administrative privileges.

  • (Linux) Ensure that the user who is performing backups and restores is a super user or has 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.

    # ln -s /<mysql_lib_install_path>/libmysqlclient.so.18 ibmysqlclient.so

  • 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