Title: Importing to wp-posts table
Last modified: August 20, 2016

---

# Importing to wp-posts table

 *  [pfhenshaw](https://wordpress.org/support/users/pfhenshaw/)
 * (@pfhenshaw)
 * [14 years, 10 months ago](https://wordpress.org/support/topic/importing-to-wp-posts-table/)
 * I finally found the way to bring my old posts from an early version of WordPress(
   that would not run an export plugin) to my new blog. I exported a .xls file from
   the old blog database table using /phpmyadmin, then reset the ID’s to 0 and saved
   it as a .csv file, to import in the new blog table. Using the bug fix needed 
   was to use “Load Data” option and change ‘;’ to ‘,’ for the “field terminated
   by”.
 * So now I have all the posts from my old blog in my new blog’s table, and they’re
   not showing up on the blog, nor found using wp-admin in the blog.
 * So something is not recognized. I don’t see wp-postmeta data for them, for example.
   Would that cause them to not appear? Is there a command to get WordPress to read
   its wp-posts and refresh its other lists?

The topic ‘Importing to wp-posts table’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [pfhenshaw](https://wordpress.org/support/users/pfhenshaw/)
 * Last activity: [14 years, 10 months ago](https://wordpress.org/support/topic/importing-to-wp-posts-table/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics