Title: Creating Posts from non-blog SQL
Last modified: August 19, 2016

---

# Creating Posts from non-blog SQL

 *  [kelvster](https://wordpress.org/support/users/kelvster/)
 * (@kelvster)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/creating-posts-from-non-blog-sql/)
 * I am looking to create around 1000 posts from our existing mysql database, but
   it’s not wordpress and it’s not a blog. The plan is to pull entries from different
   tables/fields using SQL queries, which are to become the posts in the new wordpress
   installation.
 * There doesnt seem to be any plugins for this.
 * What’s the best way to create the posts, is it creating an XML doc with the SQL,
   which would then be imported as RSS? If so, what fields are required.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/creating-posts-from-non-blog-sql/#post-871968)
 * Saw this recommended a while back:
 * 1.Install a WordPress blog.
    2.Export the blog (Manage->Export) 3.Analyse the
   resulting XML (WXR) file and use that to create your own XML file with your ‘
   posts’ 4. Use Manage->Import->WordPress to import those posts from your manufactured
   XML file.
 *  Thread Starter [kelvster](https://wordpress.org/support/users/kelvster/)
 * (@kelvster)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/creating-posts-from-non-blog-sql/#post-872213)
 * Thanks for your reply Michael.
 * It seems that you can just create a simple rss doc, with only <item> <title> 
   <description> for each entry. Useful only if you don’t have existing tags, comments
   of course, but wordpress can still import it.
 *  [eric_donovan](https://wordpress.org/support/users/eric_donovan/)
 * (@eric_donovan)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/creating-posts-from-non-blog-sql/#post-872214)
 * You could use SQL to copy the data from your old database tables direct to your
   new WordPress database assuming they’re on the same system.
 * As long as you put the data in the correct fields in the tables it should work(
   Note – I don’t know too much about WordPress but I’m assuming it just builds 
   the pages based on what it finds in the db)
 * Once you install WordPress try to add a few posts just using SQL direct to the
   DB and see what happens maybe.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Creating Posts from non-blog SQL’ is closed to new replies.

## Tags

 * [importing](https://wordpress.org/support/topic-tag/importing/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [non-blog](https://wordpress.org/support/topic-tag/non-blog/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [eric_donovan](https://wordpress.org/support/users/eric_donovan/)
 * Last activity: [17 years, 8 months ago](https://wordpress.org/support/topic/creating-posts-from-non-blog-sql/#post-872214)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics