How to collect SnapCenter database dump (NSM MySQL database dump)

Command Line

1. Log in to the SnapCenter Server where MySQL is installed 

2. Open the command prompt with elevated privileges

3. Change to the folder where MySQL is installed and run the following command

   1. Note: Please note the path and the file name specified "C:\nsm.sql" are configurable and an alternate location / file name can be specified

   2. Note: The following command will prompt the use for the root password

   3. How to reset MySQL root password (SnapCenter 4.2 and later)

   4. How to change SnapCenter Plugin for VMWare Vsphere(SCV) MySQL password

MySQL versions prior to 8.0

mysqldump.exe --user=root --host=localhost --password --protocol=tcp --port=3306 --default-character-set=utf8 --max_allowed_packet=1G --single-transaction=TRUE --routines --events "nsm" --result-file "C:\nsm.sql"

Path : "C:\"
File name : "nsm.sql" 

MySQL 8.0 and later

mysqldump.exe --user=root --host=localhost --password --protocol=tcp --port=3306 --default-character-set=utf8 --max_allowed_packet=1G --single-transaction=TRUE --routines --events "nsm" --column-statistics=0 --result-file "C:\nsm.sql"

Path : "C:\"
File name : "nsm.sql"

MySQL Workbench (GUI)

1. Install MySQL Workbench software on the Snapcenter server where MySQL software is installed
2. Log in to the SnapCenter Server where MySQL is installed 

3. Install MySQL Workbench software on the SnapCenter Server

   1. Download MySQL Workbench

   2. MySQL Community Downloads

4. Open the command prompt with elevated privileges

5. Open MySQL Workbench

6. Select Server -> Data Export

7. Select the NSM database

8. Highlight the NSM database and ensure all schema objects are selected from the right hand pane

9. Select the following options

   1. Dump Stored Procedures and Functions

   2. Dump Events

   3. Dump Triggers

10. Select Export to Self-Contained File

11. Specify the path to save the file

12. Select Include Create Schema

13. Select Create Dump in a Single Transaction (​​​​Self-contained file only)

14. Select Start Export

And finally, for either creation of the dump, when support has requested this:

1. Compress the dump file using Windows ZIP support (Windows Explorer: right-click into the directory, create new zip file, then drag & drop the output file inside)
2. Upload the zip file to NetApp to the associated Technical Support Case