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