Title: Can't import posts
Last modified: August 20, 2016

---

# Can't import posts

 *  Resolved [pete_398](https://wordpress.org/support/users/pete_398/)
 * (@pete_398)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/cant-import-posts/)
 * Hi,
 * I have been trying to go from an XOOPS site that had WordPress running in it,
   as an XOOPS module.
 * Did all the backups, wiped the site, installed 3.1.3, and then used the CSV Importer
   to load the posts. Now, for only 30 posts, there are 154 loaded, and it’s a complete
   mess. Fortunately, I also backed up WP 3.1.3 before the CSV importer.
 * I notice the dashboard has a WP importer, read up a bit, then used the ‘export’
   to see what sort of file is produced. It’s an XML file, ..so here is the big 
   question ..
 * Is there an easy method, or a plugin, to convert the SQL of the posts table to
   an XML file that I can them use for the WP import function ?
 * Pete

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

 *  [hyperdude](https://wordpress.org/support/users/hyperdude/)
 * (@hyperdude)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/cant-import-posts/#post-2149051)
 * Is there any reason why you couldn’t export to a regular WordPress XML file?
 * If you have the Db SQL file and PHPmyadmin then you can do it manually using 
   that, which I think would be the best option rather than using a plugin such 
   as CSVimporter.
 *  Thread Starter [pete_398](https://wordpress.org/support/users/pete_398/)
 * (@pete_398)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/cant-import-posts/#post-2149065)
 * > Is there any reason why you couldn’t export to a regular WordPress XML file?
 * The website is all setup with 3.1.3 and a new db. That said, I was thinking of
   simply over-writing the wp-config.php file with the old db values, as it is still
   there. Then run the export with 3.1.3. Then replace the config file back with
   the original and do the import.
 * > If you have the Db SQL file and PHPmyadmin then you can do it manually using
   > that, which I think would be the best option rather than using a plugin such
   > as CSVimporter.
 * I did do a test via phpMyadmin and exported to an XML file, but the format was
   nothing like an exported WP .XML file. Yes, the plugin wasn’t suitable for this
   situation.

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

The topic ‘Can't import posts’ is closed to new replies.

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [posts](https://wordpress.org/support/topic-tag/posts/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 2 replies
 * 2 participants
 * Last reply from: [pete_398](https://wordpress.org/support/users/pete_398/)
 * Last activity: [14 years, 11 months ago](https://wordpress.org/support/topic/cant-import-posts/#post-2149065)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics