Import Data into Light Cloud: Upload a .sql Dump or Stream It with psql

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/import-a-sql-dump

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

Import a SQL dump into a Light Cloud PostgreSQL database: upload a .sql or .sql.gz with Import dump, or stream a large dump with psql in one transaction.

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

Steps

• Step 1: Look at the file
• Step 2: Import it
• Step 3: Check the result
• Step 4: Import with psql

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.