WordPress.org

1. ebedgert
   Member
   Posted 9 months ago #

   I have an XML file of my posts only from an old SQL database (no longer have the SQL)... how do I convert this to a WXR?

   I tried just importing it anyway, and it seemed to work, but the posts do not show up.

   Here is what the file looks like...

   <?xml version="1.0" encoding="utf-8" ?>
   <!--
   -
   - phpMyAdmin XML Dump
   - version 2.10.3
   - http://www.phpmyadmin.net
   -
   - Host:
   - Generation Time: Jan 28, 2009 at 06:02 PM
   - Server version: 5.0.45
   - PHP Version: 5.1.6
   -->

   <!--
   - Database: '33544_silent_edgeorg'
   -->
   <33544_silent_edgeorg>
   <!-- Table wp_posts -->
   <wp_posts>
   <ID>4</ID>
   <post_author>1</post_author>
   <post_date>2005-10-14 07:27:00</post_date>
   <post_date_gmt>2005-10-14 11:27:00</post_date_gmt>
   <post_content> ...

   ... ETC.

2. MichaelH
   moderator
   Posted 9 months ago #

   Take a clean install of WordPress, then do the Export and look at that for clues to what you will need.

Reply

You must log in to post.