Performing the restores for MySQL databases
This topic lists the prerequisites and describes the procedure to restore the backups.
Note:
Ensure that the MySQL agent and NetBackup are of same version for successful backup and restore operations.
Before you restore the backups, you must meet the following prerequisites:
Ensure that versions of the MySQL agent and NetBackup are same. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.
Ensure that the user has administrator (Windows) or root (Linux) access.
Ensure that you restore the MySQL instance to an empty target directory.
Ensure that the target directory is a valid instance directory.
(Non-LVM) Ensure the MySQL services are running.
To restore the backups
- Configure the parameters in the
nbmysql.conffile, or specify them using the nbmysql command.For more information, See The nbmysql configuration file.
- Verify that the MySQL services are running for Non-LVM restores.
- Run the following command:
nbmysql -o restore -S master_server_name -t target_directory -p db_port [-i copy_id] [-C client_name] [-u db_user] [-H db_host]
Note:
For non-LVM restores,
DB_HOSTandDB_USERparameter are also required.