Upgrade CA Executive Insight › Backup the CA Executive Insight Configurations and Database

Backup the CA Executive Insight Configurations and Database

To create the backup, copy the files in the installation directory to a backup directory. Then, export the database using the mysqldump utility, which is normally located in the mysql/bin directory. Once the files and database are backed up, you can then restore CA Executive Insight.

If the upgrade should fail, this process creates back-up files that could be utilized to restore CA Executive Insight.

Follow these steps:

1. Stop CA Executive Insight.
2. Create a new directory to contain the backed up CA Executive Insight configuration files.
3. Copy the config subdirectory within the directory where CA Executive Insight is installed into your newly created backup directory.

   The default installation location on Windows is C:\Program Files\CA\ExecutiveInsight.

   The default installation location on Linux is /opt/CA/ExecutiveInsight.

4. Open the terminal/Command Prompt.
5. Point the terminal to the directory which has the MySQL binaries.

   For Windows, by default, it is:

   c:\Program Files\MySQL\MySQL Server 5.5\bin
   

   For Linux, by default, it is:

   c:\Program Files\MySQL\MySQL Server 5.5\usr\bin
   

6. To export your schema, enter the following commands and your MySQL passwords when prompted:

   mysqldump -p --user=<username> --add-drop-table master > <backupdir>\masterbackup.bin
   mysqldump -p --user=<username> --add-drop-table tenant1 > <backupdir>\tenant1backup.bin
   

   • <username> is the MySQL username of the user that is being used for CA Executive Insight schemas (default is execdbadmin).
   • <backupdir> is the directory where you want to store the backup files.

   If the MySQL programs are not in your path, manually specify the location of the mysqldump program in your commands.

   A backed up copy of CA Executive Insight is created.