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

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 4) Restore MySQL backup.
At the prompt “Restore using the most recent backup,” enter y, and then press Enter.

The backup MySQL database is restored to its original location.