How to restore Backup in Portainer
I installed DB Dumper and now I want to restore the Backup inside of Portainer. How would I do that?
8 Replies
:wave: Hey @Mr3DAlien,
Thanks for reaching out to us. Please follow the recommended actions below; this will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker compose ps docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
Checklist
1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: I have read applicable release notes.
3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
4. :ballot_box_with_check: I have reviewed Github for known issues.
5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
7. :blue_square: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
If this ticket can be closed you can use the /close command, and re-open it later if needed.@Mr3DAlien uploaded
you need to either run pgadmin or get access to a command line to restore the database dump
you can use the DB_SKIP_MIGRATIONS environment var (check the docs) to prevent the database from being edited by immich
I'll be honest I am really new to the whole Portainer thing, So could you maybe tell me where I could do that
not sure, you'll have to use the command line of your linux system
can i just use the command line and that will work with portainer? do I need to change anything about the restore command at all or should it just work as it is
Yes, you should be able to use docker exec
Did you manage to do this in portainer ?
I need to restore the database as its corrupted. Any steps you can tell will be greatly appreciated.