© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
ImmichI
Immich•3y ago•
5 replies
stathisk

Restoring database, a lot of MySQL errors.

I've followed the directions on the Backup and Restore page: https://immich.app/docs/administration/backup-and-restore
Problem is I get a lot of SQL errors when running the
gunzip < "/path/to/backup/dump.sql.gz" | docker exec -i immich_postgres psql -U postgres -d immich    # Restore Backup
gunzip < "/path/to/backup/dump.sql.gz" | docker exec -i immich_postgres psql -U postgres -d immich    # Restore Backup
command. Result is the admin account works, but no photos are imported.
Log is attached.
Immich has never ran, it's a fresh install, just created using the commands on the page above, also tried with
docker-compose up --no-start
docker-compose up --no-start
instead of
docker-compose create
docker-compose create
. But no luck!
message.txt9.37KB
Backup and Restore | Immich
Database
ImmichJoin
A place to hang out, get support, discuss Immich, get announcements about releases and anything else going on.
36,590Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Issue restoring a database backup
ImmichIImmich / help-desk-support
3y ago
Postgres errors when restoring
ImmichIImmich / help-desk-support
10mo ago
Help restoring database data.
ImmichIImmich / help-desk-support
2mo ago
Problem with restoring database
ImmichIImmich / help-desk-support
4mo ago