Download all data in SQL

Data & reporting
1

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.

1 Like
2

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.

3 Likes
3

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?

1 Like
4

Correct - it works in the background while the database hums along. No disruption at all.

1 Like
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.