Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > Commands for WHD database export and import

Commands for WHD database export and import

Example of commands needed to export/import the database.

 

Source server

  1. Stop WHD
  2. Open a command line and execute:
    WHD_INSTALL_DIR/pgsql9/bin
  3. Export the database by executing the following command:
    pg_dump -Fc -v -p 20293 -U whd whd > whd.pgdump
  4. Move whd.pgdump to the new server. 

Destination server

 

  1. Stop WHD.
  2. Navigate to WHD_INSTALL_DIR/pgsql9/bin.
  3. If there is already an initialized whd database in place, rename the database using following commands in the psql tool:
    psql -U whd -d template1
    ALTER DATABASE whd rename to whd_old;
  4. Create an empty whd database in psql tool:
    CREATE DATABASE whd;
  5. Restore the database. Exit the psql tool first (\q) to return to the cmd directory (directory WHD_INSTALL_DIR/pgsql9/bin):
    pg_restore -Fc -v -p 20293 -U whd -d whd "path_to_whd.pgdump"
Last modified
16:03, 3 May 2017

Tags

Classifications

Public