Restoring the OpsCenter database
You can restore the database that you have backed up earlier. On Windows and UNIX hosts, the restore operation automatically stops the database, restores the backup database files along with the database password file and encryption key file, and restarts the database. The dbbackup script overwrites existing database (db) files before backing up or restoring the database or the database password file.
Note:
It is strongly recommended that you change the password for the admin user account after you restore the OpsCenter database.
To restore a backed up OpsCenter database
- On the OpsCenter server with backup data you want to restore, open a UNIX console or a Windows command prompt and log on as root (on UNIX) or as an administrator or user in the Administrators group (on Windows).
Windows
Open a Windows command prompt and log on as an administrator or user in the Administrators group.
UNIX
Open a UNIX console and then log on as root.
All the paths that are shown in the steps that follow are the default database install paths. These paths may different for your site if the database was installed anywhere other than the default location.
- To restore the backed up database, do one of the following:
Windows
Type the following command and press Enter.
INSTALL_PATH\OpsCenter\server\bin\dbbackup.bat backupDir -restore
UNIX
Type the following command and press Enter.
INSTALL_PATH/SYMCOpsCenterServer/bin/dbbackup.sh backupDir -restore
backupDir is the directory where the backed up database files, database password file, and encryption key file reside.
The script prompts you with a message similar to the following:
WARNING: this operation will overwrite the active OpsCenter data on this host. Do you wish to continue ? [y/n] (n)
- To continue with the restore, press Enter on Windows hosts.
To continue with the restore, type y on UNIX hosts.
The dbbackup script automatically stops and restarts the database.