Tools

Move the WHD database to another disk on the same server

This article describes how to move the Web Help Desk database to another disk (from C to E) on the same server.

First published date

10/19/2018 8:50 PM

Last published date

10/19/2018 8:50 PM

Overview

This article explains how to move the WHD database to another disk (from C to E) on the same server.

Product section

Web Help Desk

Resolution

  1. Back up your Web Help Desk database to a separate location. 
  2. Uninstall Web Help Desk  from the current location. 
  3. Install Web Help Desk  in the new location.
  4. Navigate to:
    C:\Program Files\WebHelpDesk\pgsql9\bin
  5. Run pgAdmin3.
  6. In the pgAdmin III window, click File > Add Server.
  7. Add the following:
    • Name: WHDDB
    • Host: localhost or IP address
    • Port: 20293
    • Maintenance DB: postgres
    • Username: whd
    • Password: whd
  8. Expand Databases.
  9. Right-click whd and select Delete/Drop from the menu.
  10. Click Yes
  11. Right-click Databases.
  12. Select New Database and set the following:
    • Name: whd
    • Owner: whd
  13. Right-click on whd and select Restore.
  14. On the popup window, select the following:
    Format: Directory
    Filename: "browse to the directory where the database backup file is location". Example: E:\WHD_DB_Backup\whd.backup
  15. Click Restore.