restore a ful backup.gz file

[thierry-carron]

Hi there, (I am new)
I don't see how to select a local backup.gz file to full reload into new blank project ?https://supabase.com/dashboard/project/fxxxxxxxxxxxxxxxxxxxxxxxxxxxx/database/backups/scheduled

[thierry-carron]

nobody to help here ????

[brunowego]

Follow the steps below, you will see that the .backup file is an SQL file.

Download Backup

1. Supabase Projects
2. Select a project
3. Mein Menu -> Database
4. Aside Menu -> Platform -> Backups
5. Database Backups -> Scheduled backups (Tab) -> Select one -> Download

Restore Backup (Local)

#
gunzip <filename>.backup.gz

#
file --mime-type <filename>.backup

#
head -n 20 <filename>.backup

[mauriciopiber]

Great solution, worked like a charm.

[brunowego]

Below is a tip on how to import locally:

#
sed -i 's/^\(\\connect postgres\)$/\\connect acme/' <filename>.backup

#
export DATABASE_URL='postgresql://acme:acme@localhost:5432/acme'

#
psql -d "$DATABASE_URL" -c 'ALTER USER acme WITH SUPERUSER'

#
psql -d "$DATABASE_URL" < ./<filename>.backup

The default Supabase database name is postgres, sed is for you to change it to another name.

[brunowego]

It is normal to show some errors in the output, you can ignore them... and wait until it finishes.

[mauriciopiber]

@brunowego yep with all those tips it become easy.

I just had to create the user, password and database locally + your code and everything worked.

Thanks! You're the best.