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?
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.
4 Likes
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.
3 Likes
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.
3 Likes