How to collect SnapCenter database dump (NSM MySQL database dump)
Applies to
SnapCenter Server
Description
How collect a SnapCenter repository (NSM) MySQL database dump for further troubleshooting by NetApp
Procedure
Command Line
-
Log in to the SnapCenter Server where MySQL is installed
-
Open the command prompt with elevated privileges
-
Change to the folder where MySQL is installed and run the following command
-
Note: Please note the path and the file name specified
"C:\nsm.sql"
are configurable and an alternate location / file name can be specified -
Note: The following command will prompt the use for the root password
-
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" --result-file "C:\nsm.sql"
Path : "C:\"
File name : "nsm.sql"
MySQL Workbench (GUI)
- Install MySQL Workbench software on the Snapcenter server where MySQL software is installed
- Log in to the SnapCenter Server where MySQL is installed
-
Install MySQL Workbench software on the SnapCenter Server
-
Open the command prompt with elevated privileges
-
Open MySQL Workbench
-
Select Server -> Data Export
-
Select the NSM database
-
Highlight the NSM database and ensure all schema objects are selected from the right hand pane
-
Select the following options
-
Dump Stored Procedures and Functions
-
Dump Events
-
Dump Triggers
-
-
Select Export to Self-Contained File
-
Specify the path to save the file
-
Select Include Create Schema
-
Select Create Dump in a Single Transaction (Self-contained file only)
-
Select Start Export
And finally, for either creation of the dump, when support has requested this:
- 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)
- Upload the zip file to NetApp to the associated Technical Support Case