Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > 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 by running the command,  WHD_INSTALL_DIR/webhelpdesk/whd stop
  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 -p 20293 -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

Tags

Classifications

Public