Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Web Help Desk (WHD) > Move the WHD database to another disk on the same server

Move the WHD database to another disk on the same server

Table of contents
Created by Miroslav Beno, last modified by MindTouch on Jun 23, 2016

Views: 52 Votes: 0 Revisions: 3

Overview

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

Environment

All WHD versions with integrated PostgreSQL DB

Steps

  1. Go to Setup > General > Database > Backup now to create a backup of the current database.
  2. Uninstall WHD completely. Refer to How do I uninstall Help Desk?
  3. Install WHD to a new location. Refer to Installing the Application.
  4. Go to C:\Program Files\WebHelpDesk\pgsql9\bin
  5. Run pgAdmin3
  6. On the pgAdmin III window, go to 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. Locate the backup file of the PostgreSQL DB. 
  15. Click Restore.

 

Last modified
04:42, 23 Jun 2016

Tags

Classifications

Public