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.

Database restoration is not required unless a failure occurs. Take the cleanup steps that are described in Clean Up After a Failed Installation before you attempt the installation again. Then take the steps in this procedure.

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.