How can I pull all the urls from discourse including all the paging urls from database? and transport them into a xml or csv file?
For topics at least, you should be able to query the table and identify all topics by ID to synthesize the URLs.
Install the data explorer plugin and import this query:
all-outbound-links.dcquery.json (197 Bytes)
Run it, then use the “Download Results” button.