Export all data of all posts

Is it possible to export the data of all posts?

1 Like

I don’t know all of the ways but the most practical way would be if you have Discourse admin rights then

In the upper right click Hamburger menu.
Click Admin.
Scroll down until you see Backups.
Click on Backups which will take you a new page listing the backups available.
Click download and follow the instructions which uses an e-mail to verify you are really who you claim to be.
IIRC this results in a *.tar.gz file
From the *.tar.gz file the *.sql file can be extracted and used to populate a new empty database in a PostgreSQL database.

Note that posts is a table and has two columns that hold data about a post, raw which is the text as entered and cooked which is closer to the HTML you see but I don’t exactly how to cook the raw as I am not a chef. :grinning:

HTH

1 Like

Can you elaborate on what you are trying to do? Do you want a backup of the entire database? Do you want the content of some specific topics/posts? What’s your end goal?

3 Likes

Hi @HAWK, I need all the content from the posts.

Using the backup options outlined above will give you a machine readable file with all posts content (and more).

2 Likes