Migrating the SnapCenter repository

You can migrate the SnapCenter Server database repository from the default location to another disk. You might migrate the repository when you want to relocate it to a disk with more space.

Steps

  1. Stop the MYSQL57 service in Windows.
  2. Locate the MySQL data directory.
    You can usually find the data directory at C:\ProgramData\MySQL\MySQL Server 5.7\Data.
  3. Copy the MySQL data directory to the new location, for example, E:\Data\nsm.
  4. Right click on the new directory, and then select Properties > Security to add the Network Service local server account to the new directory, and then assign the account full control.
  5. Rename the original database directory, for example, nsm_copy.
  6. From a Windows command prompt, create a symbolic directory link by using the mklink command.
    Example
    "mklink /d "C:\ProgramData\MySQL\MySQL Server 5.7\Data\nsm" "E:\Data\nsm" "
  7. Start the MYSQL57 service in Windows.
  8. Verify that the database location change is successful by logging in to SnapCenter and checking repository entries, or by logging in to the MySQL utility and connecting to the new repository.
  9. Delete the original, renamed, database repository directory (nsm_copy).