Skip to main content
NetApp Knowledge Base

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

Views:
5,047
Visibility:
Public
Votes:
3
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

SnapCenter Server

Description

How collect a SnapCenter repository (NSM) MySQL database dump for further troubleshooting by NetApp

Procedure

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

 

Scan to view the article on your device
CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support