search

chaos-jetzt / chaos-jetzt-nixfiles

5 stars 2 forks source link

services/freescout: Initial setup #6

Closed e1mo closed 1 year ago

e1mo commented 1 year ago

Initial setup for the FreeScout Helpdesk are currently using as a ticket system.

In terms of migrating data and everything:

  1. Dump old database and copy it over: sudo -u postgres pg_dump freescout > freescout.sql; scp freescout.sql e1mo@shirley.net.chaos.jetzt:
  2. Stop all freescout services: sudo systemctl stop freescout-*.timer
  3. drop the freescout database: sudo -u postgres psql -c "DROP DATABASE freescout;"; sudo systemctl restart postgresql.service
  4. Import the old db dump: sudo -u postgres psql freescout < /run/freescout_20220106.sql.
  5. Copy /var/www/freescout/storage/app/attachment/ to the new host