I have a discourse from, and I have the permission to server, how can I to export all the posts data from the server side? Or we have other ways to export all the posts?
AI-generated summary
Users are discussing ways to download all posts from a Discourse server. Ed_S suggests downloading from a backup, which can be found in /var/discourse/shared/standalone/backups/default/ or through the admin page’s backup section. Arkshine and Ed_S agree that the backup is the easiest solution. Alternatively, the Data Explorer plugin can be used to export specific data in CSV/JSON format. pfaffman notes that the choice of method depends on the intended use of the posts, such as moving to another platform or using in a spreadsheet.
Downloading from a backup might be easiest, if the backups are kept on the server.
The backup files are usually found in
/var/discourse/shared/standalone/backups/default/
and I’d usually use scp or rsync to copy them to my machine.
Or, on the backup section of the admin page you see a list of backups, each with a download button, which sends you a backup link by email. An admin could cause that email to be sent to them and they can forward the link.
I agree; the backup seems to be the easiest solution.
It also depends on what you’re looking for.
If you need specific data, you may also be interested in the Data Explorer plugin, which exports in CSV/JSON.
The answer depends on what it is you plan to do with the posts.
If you want to move them to another forum platform then the regular backup that has the SQL dump is what is most useful.
If you want to do something with them in a spreadsheet, then data explorer might be the way to go.