Is it possible to export the data of all posts?

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 fol…

@Falco Is there a way to get a human readable file with all the post’s content? I’m trying to avoid going post by post and copy/pasting to google docs :slight_smile:

I tried this but when I try to run the .sql file in on my PostgreSQL database, I get a syntax error: ERROR: syntax error at or near "1" LINE 5066: 1 33a64b9c942fe3f0b264467590ac83a2207b557db26e86ec8d3ebcf605... ^ SQL state: 42601 Character: 126056 Any advice?

Exporter toutes les données de tous les messages

Soutien

gergnd (Greg Docter) Novembre 6, 2020, 3:12 7

@Falco Existe-t-il un moyen d’obtenir un fichier lisible par un humain contenant tout le contenu des publications ?

J’essaie d’éviter de parcourir chaque publication pour copier/coller dans Google Docs

Sujet		Réponses	Vues
Download all data in a presentable/user friendly format Support	1	569	Août 11, 2022
How to download all the posts? Support	3	631	Mai 6, 2024
Exporting data from version 0.9.4 installed through bitnami Marketplace unsupported-install , backups	4	2314	Avril 6, 2016
How can I directly edit Discourse database from a GUI? Self-hosting	20	3996	Mai 14, 2020
Importing a Discourse backup into a PostGreSQL DB Self-hosting	2	629	Mars 19, 2019

Exporter toutes les données de tous les messages

Sujets connexes