Help Desk Manager - How to Backup and Restore through Command Line

Last Modified

Wed Jan 04 19:10 GMT 2023

Description

• When migrating Help Desk Manager to a new server

Environment

• N-able Help Desk Manager

Solution

1. Stop HDM application on original server
   • C:\Program Files\N-able Technologies\Help Desk Manager\whd_stop.bat (right click and run as administrator)
2. Take a copy of the whd.conf, found at:
   • C:\Program Files\N-able Technologies\Help Desk Manager\conf\whd.conf
3. Backup PostgreSQL embedded database using HDM, PGAdmin tool or PostgreSQL commands on the original server.

• Help Desk Manager backup schedule and location

3. Install/Deploy HDM v12 on the other system
4. Go through Getting Started Wizard, choose embedded DB (default PostgreSQL)
5. Once finished, stop HDM application on the target server
   • C:\Program Files\N-able Technologies\Help Desk Manager\whd_stop.bat (right click and run as administrator)
6. Copy PostgreSQL database backup from original server to target server
7. Connect to database using:
   • pgsql9\bin\psql -h 127.0.0.1 -p 20293 -U whd -d template1
8. Rename/Drop default empty PostgreSQL embedded database
   1. cd C:\ProgramFiles\N-able Technologies\Help Desk Manager
      • NOTE: If prompted for password use whd
   2. Execute following statements:
      1. ALTER DATABASE whd rename to whd_old;
      2. CREATE DATABASE whd;
      3. \q
9. Restore PostgreSQL database backup using PGAdmin tool or PostgreSQL commands on the target server
   1. cd C:\ProgramFiles\N-able Technologies\Help Desk Manager
      • NOTE: If prompted for password use: whd
   2. pgsql9\bin\pg_restore -Fc -v -h 127.0.0.1 -p 20293 -U whd -d whd path_to_whd.pgdump
10. Start WHD application on the target server
    • C:\Program Files\N-able Technologies\Help Desk Manager\whd_start.bat (right click and run as administrator)
11. Open HDM application in browser
12. If the Domain host name of the target server is different to the domain host name of original server, navigate to Setup > General > Options and change Server DNS Name.
    • NOTE: You also may wish to copy your configuration file from your old server
13. Stop HelpDesk Manager services on the new server
    • Alternatively, run the following in a command prompt window: C:\Program Files\N-able Technologies\Help Desk Manager\whd_stop.bat
14. Copy C:\Program Files\N-able Technologies\Help Desk Manager\conf\whd.conf from your old server to your new server
15. Start HelpDesk Manager services on the new server
    • Alternatively, run the following in a command prompt window: C:\Program Files\N-able Technologies\Help Desk Manager\whd_start.bat