Skip to main content

NetApp wins prestigious Coveo Relevance Pinnacle Award. Learn more!

INSIGHT Japan :2023年 1月25日(水)ANAインターコンチネンタルホテル開催 へ参加・申込を行う

NetApp Knowledge Base

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

Last Updated:

Applies to

SnapCenter Server


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


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" --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


Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device