Database Backup Procedures › Restore the Database after a Reinstallation

Restore the Database after a Reinstallation

Restore the CA Performance Center database from a backup archive after you reinstall the software. Restoring the database from a backup preserves data continuity and enables most historical reporting after a failure occurs.

Note: Database restoration is not required unless a failure occurs. For upgrade failure situations, follow the steps in Recover from an Upgrade Failure.

Follow these steps:

1. Log in to the server as root, or use the sudo account you configured for the installation.
2. 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
   

   The services are stopped.

3. Change to the directory where you saved the backup archive. For example:

   cd $backupDir
   

4. Uncompress the database backup archives for CA Performance Center and Event Manager by executing the following commands:

   tar zxvf netqosportal.tgz
   tar zxvf em.tgz
   

5. Import the uncompressed CA Performance Center backup file:

   mysql netqosportal -e ‘source $backupDir/netqosportal.sql’
   

6. Import the uncompressed Event Manager backup file:

   mysql em -e ‘source $backupDir/em.sql'
   

7. Start all of the CA Performance Center services:

   /etc/init.d/caperfcenter_eventmanager start
   /etc/init.d/caperfcenter_devicemanager start
   /etc/init.d/caperfcenter_sso start
   /etc/init.d/caperfcenter_console start
   

8. Delete the uncompressed archive files to save space:

   rm netqosportal.sql
   

   rm em.sql
   

9. Log in to CA Performance Center as an administrator.
10. Verify that your configuration data appears in Admin pages.