Tech Tip: How to backup a single mysql table and restore it on capc

Document created by Yulun.Zhang Employee on Oct 2, 2015Last modified by SamCreek on Dec 17, 2016
Version 3Show Document
  • View in full screen mode

Here is the steps for backingup a single mysql table and restore it on capc. Here I use table dst_device for demonstrating the steps

1. Stop all of the CA Performance Center services using the following commands:

/etc/init.d/caperfcenter_eventmanager stop

 

/etc/init.d/caperfcenter_devicemanager stop

/etc/init.d/caperfcenter_sso stop

/etc/init.d/caperfcenter_console stop

 

2. Run the following command to backup table dst_device to des_device.sql, netqosportal is the database name

/opt/CA/MySql/bin/mysqldump -u root netqosportal dst_device > dst_device.sql

 

3. Run the following command to restore table dst_device

/opt/CA/MySql/bin/mysql -u -p netqosporta < dst_device.sql

Attachments

    Outcomes