Back Up a Database: Download a SQL Dump and Restore It

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/export-a-database-backup

Part 4 of 8 of the series Databases on Light Cloud.

Back up a Light Cloud PostgreSQL database: download a .sql.gz dump from the Backup tab, restore it into a new database with psql, and script it with pg_dump.

Level: Beginner · Time: about 10 minutes · Plan: Lite · Stack: PostgreSQL, psql, pg_dump

Steps

• Step 1: Download the backup
• Step 2: Look inside
• Step 3: Restore into a new database
• Step 4: Back up from the terminal
• Step 5: Delete the copy

Source code: https://github.com/light-cloud-com/tutorial-database-basics

---

Questions, problems with a step, or a screen that no longer matches the console? Reply here. Every tutorial is re-run on the live platform before it is published, and this thread is where fixes get discussed.