# Download all data in SQL
**URL:** https://meta.discourse.org/t/download-all-data-in-sql/259608
**Category:** Data & reporting
**Created:** [March 27, 2023, 7:28pm UTC](https://meta.discourse.org/t/download-all-data-in-sql/259608 "2023-03-27T19:28:20Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Luiz\_men](https://meta.discourse.org/u/Luiz_men)
#### Post date: [March 27, 2023, 7:28pm UTC](https://meta.discourse.org/t/download-all-data-in-sql/259608/1 "2023-03-27T19:28:20Z")
Hi!
I would like to know how I can download all my community data in SQL format.
I searched here in the community but I didn’t find a post that talks exactly about this.
---
### Author:  [@leonardo](https://meta.discourse.org/u/leonardo)
#### Post date: [March 27, 2023, 7:33pm UTC](https://meta.discourse.org/t/download-all-data-in-sql/259608/2 "2023-03-27T19:33:49Z")
Hi Luiz! If you’re administrator, you can simply create and download a backup from the admin section, which is exactly that - the output of PostgreSQL’s `pgdump`, which perfectly recreates the database with SQL statements.
As a regular user however, that is not an option. You need to be an administrator for access to the entire database, for obvious reasons.
---
### Author:  [@Luiz\_men](https://meta.discourse.org/u/Luiz_men)
#### Post date: [March 27, 2023, 7:38pm UTC](https://meta.discourse.org/t/download-all-data-in-sql/259608/3 "2023-03-27T19:38:40Z")
Hi, Leonardo!
Thanks for the answer!
Just to be sure, when clicking to make a new backup it just generates the file for download without any interference in the community content, right?
---
### Author:  [@leonardo](https://meta.discourse.org/u/leonardo)
#### Post date: [March 27, 2023, 7:50pm UTC](https://meta.discourse.org/t/download-all-data-in-sql/259608/4 "2023-03-27T19:50:00Z")
Correct - it works in the background while the database hums along. No disruption at all.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [April 26, 2023, 7:50pm UTC](https://meta.discourse.org/t/download-all-data-in-sql/259608/5 "2023-04-26T19:50:27Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.