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
Last published date
Overview
This article explains how to move the WHD database to another disk (from C to E) on the same server.
Product section
Resolution
- Back up your Web Help Desk database to a separate location.
- Uninstall Web Help Desk from the current location.
- Install Web Help Desk in the new location.
- Navigate to:
C:\Program Files\WebHelpDesk\pgsql9\bin - Run pgAdmin3.
- In the pgAdmin III window, click File > Add Server.
- Add the following:
- Name: WHDDB
- Host: localhost or IP address
- Port: 20293
- Maintenance DB: postgres
- Username: whd
- Password: whd
- Expand Databases.
- Right-click whd and select Delete/Drop from the menu.
- Click Yes
- Right-click Databases.
- Select New Database and set the following:
- Name: whd
- Owner: whd
- Right-click on whd and select Restore.
- 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 - Click Restore.