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?

导出所有帖子的全部数据

支持

gergnd (Greg Docter) 2020 年11 月 6 日 15:12 7

@Falco 有没有办法获取一个包含所有帖子内容的、人类可读的文件？

我想避免逐个帖子地复制粘贴到 Google 文档中

话题		回复	浏览量
Download all data in a presentable/user friendly format Support	1	568	2022 年8 月 11 日
How to download all the posts? Support	3	629	2024 年5 月 6 日
Exporting data from version 0.9.4 installed through bitnami Marketplace unsupported-install , backups	4	2314	2016 年4 月 6 日
How can I directly edit Discourse database from a GUI? Self-hosting	20	3994	2020 年5 月 14 日
Importing a Discourse backup into a PostGreSQL DB Self-hosting	2	628	2019 年3 月 19 日

导出所有帖子的全部数据

相关话题