# Migrate or move Discourse content into a blog post - HOW?

**URL:** https://meta.discourse.org/t/migrate-or-move-discourse-content-into-a-blog-post-how/292656
**Category:** Support
**Created:** [January 23, 2024, 6:30pm UTC](https://meta.discourse.org/t/migrate-or-move-discourse-content-into-a-blog-post-how/292656 "2024-01-23T18:30:41Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![deb\_mitchell](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/deb_mitchell/32/246259_2.png) [@deb\_mitchell](https://meta.discourse.org/u/deb_mitchell)
#### Post date: [January 23, 2024, 6:30pm UTC](https://meta.discourse.org/t/migrate-or-move-discourse-content-into-a-blog-post-how/292656/1 "2024-01-23T18:30:42Z")

</div>

I need to move some content out of my Discourse site. We are working on an additional WordPress blog site where the info will be duplicated. What’s the fastest, best way to do this?

The content consists of posts with words, photos and sometimes embedded YouTube links.

Open to content going directly to Wordpress or even another location where we can then create specific Wordpress posts.

Thanks for any direction

---

<div class="post-metadata">

### Author: ![volanar](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/volanar/32/318163_2.png) [@volanar](https://meta.discourse.org/u/volanar)
#### Post date: [January 23, 2024, 7:22pm UTC](https://meta.discourse.org/t/migrate-or-move-discourse-content-into-a-blog-post-how/292656/2 "2024-01-23T19:22:56Z")

</div>

I did it manually, but I didn’t have much content. But instead, wordpress chose drupal as a more advanced CMS that supports custom fields in the core

---

<div class="post-metadata">

### Author: ![jericson](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jericson/32/116215_2.png) [@jericson](https://meta.discourse.org/u/jericson)
#### Post date: [January 23, 2024, 8:12pm UTC](https://meta.discourse.org/t/migrate-or-move-discourse-content-into-a-blog-post-how/292656/3 "2024-01-23T20:12:55Z")

</div>

Seems like importing Markdown files into WordPress would be key. I see there is [a plugin](https://wordpress.org/plugins/import-markdown/) that claims to do that.

From the Discourse side, I’d use a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query that looks something like:

```plaintext
select title, p.user_id, p.created_at, raw
from posts p
     join topics t on t.id = topic_id
where post_number = 1 

```

This gets the first post in each topic. You might need to limit it to a different subset.

Alternatively you could get the `cooked` post which is HTML. On second thought that might be easier to import into WordPress.

Another option might be to [use the API to grab the posts](https://meta.discourse.org/t/how-to-iterate-over-all-the-topics-in-order-to-export-them-as-markdown/220180).