Title: Moving posts
Last modified: August 20, 2016

---

# Moving posts

 *  [patc890](https://wordpress.org/support/users/patc890/)
 * (@patc890)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/moving-posts-5/)
 * Hi, I had a WP site hosedt with a provider. I moved it to my own server with 
   very few problems. I now find out that one person has been using the old site(
   should have closed it down) and made many posts to it. The new location also 
   has had a few posts added. Is there any way I can migrate the posts from the 
   old site over? I can get a dump of the wp_posts table.
    I tried to add them to
   the new site bit got an error.. ERROR 1062 (23000) at line 65: Duplicate entry‘
   6’ for key ‘PRIMARY’
 * I also tried dropping the wp_posts table in the new DB (less posts) and importing
   the one from the old site. It took them ok but put them all on the main page 
   of the site?
 * Is there anyway to migrate these posts over?
 * Thanks.
 * Pat.

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

 *  [mailworm](https://wordpress.org/support/users/mailworm/)
 * (@mailworm)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/moving-posts-5/#post-2307096)
 * When adding them, try to remove the primary var and value from any line.
 *  [mailworm](https://wordpress.org/support/users/mailworm/)
 * (@mailworm)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/moving-posts-5/#post-2307101)
 * Sorry, I was way too fast..
 * When doing the inserts via SQL (phpmyadmin or similar) You have to remove ‘ID’
   from any line and the corresponding value.
 * INSERT INTO `wp_posts` (`ID`, `post_author`, …) VALUE (6, ‘Me’, …)
 * In this case remove **‘ID’,** and **6, **.
 *  Thread Starter [patc890](https://wordpress.org/support/users/patc890/)
 * (@patc890)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/moving-posts-5/#post-2307102)
 * Great thanks I’ll try that.
 * Pat.
 *  Thread Starter [patc890](https://wordpress.org/support/users/patc890/)
 * (@patc890)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/moving-posts-5/#post-2307175)
 * Hi again,
 * Just to be sure. I have this…
 * INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`,………
    and VALUES (6, 
   1, ‘2011-08-10 09:19:07’,…..
 * So I should use?
 * INSERT INTO `wp_posts` (`post_author`, `post_date`,………
    and VALUES (1, ‘2011-
   08-10 09:19:07’,…..
 * Pat.

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

The topic ‘Moving posts’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [patc890](https://wordpress.org/support/users/patc890/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/moving-posts-5/#post-2307175)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics