Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Move a DPA repository on MySQL

Move a DPA repository on MySQL

Table of contents
Created by Anthony.Rinaldi_ret, last modified by Chris.Moyer_ret on Sep 23, 2016

Views: 1,027 Votes: 0 Revisions: 6

Updated July 5, 2016


This article explains how to move a DPA repository from one MySQL database to another.

If you need to move a SQL Server or Oracle repository, see the following:


  • DPA 10.2 and later


  1. In DPA, click Stop All Monitors in the upper right.
  2. Shut down DPA.
    • Windows: Stop the IgnitePI service.
    • Linux: Run in the DPA installation directory. Ensure there are no crontab entries that will restart DPA.
  3. Create a new empty database on the destination MySQL instance:
    mysqladmin -u username --password="password" -h destination_hostname 
    create databasename_name
  4. Copy the database to the destination server:
    mysqldump -u username --password="password" current_db_name | mysql 
    -u destination_username --password="destination_password" -h hostname 

    For more information, see the MySQL documentation.

  5. On the DPA server, open the file in a text editor.
    • Windows: This file is located at DPA_install_dir\iwc\tomcat\ignite_config\idc
    • Linux: This file is located at DPA_home/iwc/tomcat/ignite_config/idc
  6. Edit the values for the following lines to point to the new repository:
  7. Start DPA.
    • Windows: Start the IgnitePI service.
    • Linux: Run in the DPA installation directory.
  8. In DPA, make sure the server connects to the new MySQL repository database.
  9. Review the status of the database monitors, and start or stop them accordingly.
  10. Review the DPA log for errors.
  11. Wait for 10 minutes, and drill down into each monitored database instance.
  12. Make sure that you see data from the last 10 minutes for the database instances.




Last modified