Docker compose restore

Technical assistance
1

Infos:

  • Used Zammad version: 6.0
  • Used Zammad installation type: docker compose
  • Operating system:
  • Browser + version:

does anybody know, how to “restore” a backup in docker? i only found quiet old ways, but they are not working anymore :frowning:

2

If you have all attachments in the database, stopping all containers except for the database one and then restoring your database dump against standard in to the container should do the trick.

Something like this might work:
cat backup.sql | docker compose exec -T zammad-postgresql psql --username zammad --dbname zammad_production

You may also have to drop and re-create the database in question.
Note that I have not verified above command. Proceed with care and snapshots.