Before You Begin

There are two scripts used to backup and restore the HelpSystems Insite database (backupdatabase.bat and restoredatabase.bat). Both scripts reside in the HelpSystems Insite root directory on the server.

Environment Location
Windows C:\Program Files(x86)\Help Systems\HelpSystems Insite\
Linux (Root install) /opt/helpsystems/insite/server/{backup|restore}database.sh
Linux (User install) {USER_HOME}/helpsystems/insite/server/{backup|restore}database.sh

In order to use these scripts, the database service must be running.

Backing Up HelpSystems Insite

To back up the database, run the following command:

  • Windows: backupdatabase.bat
  • UNIX/Linux: ./backupdatabase.sh

This command creates a backup file of the database named:

     helpsystemsinsite_YYYYMMDDhhmmss.backup

     where YYYY is the year, MM is the month, DD is the day, hh is the hour, mm is the minute, and ss is the seconds.

The script puts the backup file in the root directory of the product.

Restoring HelpSystems Insite

Notes:

  • We highly recommend that you stop the HelpSystems Insite Server service and the HelpSystems Insite Analytics Service before performing a restore.
  • The database service (HelpSystemsDatabaseServer) must be running.

To restore the database, run the following command (it's also found in the HelpSystems Insite root directory):

  • Windows: restoredatabase.bat
  • UNIX/Linux: ./restoredatabase.sh

This command takes a backup file created by the backupdatabase script and restores it to the database.

The file path is passed to the script.

Command example:

restoredatabase.bat helpsystemsinsite_20160617140042.backup

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 04, 2018