Veritas NetBackup™ for MySQL Administrator's Guide

To redirect a restore to a different host

1. Update the nbmysql.conf file with the NetBackup client name as the host and the MySQL target directory as the directory where you want to redirect the restore.
2. On the NetBackup master server, create an altnames directory for the host that you want to have permission to perform the redirected restore. For example, to give Host B permissions to restore from another host, create the following file:

   • (Windows) install_path\NetBackup\db\altnames\HostB

   • (Linux RHEL and SLES) /usr/openv/netbackup/db/altnames/HostB

3. In the altnames directory, add the names of the client(s) whose files the requesting client wants to restore. For example, if you want Host B to have permissions to redirect restores from Host A, add Host A to the Host B file.
4. Run the following command:

   nbmysql -o restore -S master_server_name -t target_directory -p db_port [-i copy_id] [-C client_name]

5. After a successful redirected restore, undo the changes that you made on the master server and the client.

To redirect a restore to a different file path

1. Run the following command:

   nbmysql -o restore -S master_server_name -t target_directory -p db_port [-i copy_id] [-C client_name]

2. After a successful restore, make the following changes:

   • (Linux) To change the ownership of the files and directories to MySQL, run the following command:

     $chown -R mysql <data_dir>

     $chgrp -R mysql <data_dir>

3. Copy the restore data to the data directory.