You can use the maintenance console to restore a specific backup of the MySQL database (also called an NSM database) for the SnapCenter Plug-in for VMware vSphere virtual appliance.

Steps

Open a maintenance console window.

Access the Maintenance Console.
From the Main Menu, enter option 1) Application Configuration.
From the Application Configuration Menu, enter option 6) MySQL backup and restore.
From the MySQL Backup and Restore Configuration Menu, enter option 2) List MySQL
backups, and then make a note of the backup you want to restore.
From the MySQL Backup and Restore Configuration Menu, enter option 4) Restore MySQL backup.
At the prompt “Restore using the most recent backup,” enter n.
At the prompt “Backup to restore from,” enter the backup name, and then press Enter.

The selected backup MySQL database is restored to its original location.