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

Use Command Line method.

1. Log in to the SnapCenter Server via Remote Desktop or Console.

2. Open the command prompt with elevated privileges

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

   1. Note: The default MySQL install path is "C:\Program Files\MySQL\MySQL Server 5.7\bin"

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

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

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

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

(There is no need to export the NSM database with the --routines --events parameters.)

4. Compress the dump file using Windows ZIP or 7zip
5. Upload the zip file to NetApp to the associated Technical Support Case