Title: data copy
Last modified: August 18, 2016

---

# data copy

 *  [46664](https://wordpress.org/support/users/46664/)
 * (@46664)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/)
 * i have a mulitple blog installation.now how can i copy my posts and comments 
   to the other blog wihtout messing up?

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249013)
 * Export the database, then re-import it.
    That’s about it really… [http://www.tamba2.org.uk/wordpress/move2/](http://www.tamba2.org.uk/wordpress/move2/)
 *  Thread Starter [46664](https://wordpress.org/support/users/46664/)
 * (@46664)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249016)
 * thats exactly i did and i get error importing because it says that its already
   exists.
 *  Thread Starter [46664](https://wordpress.org/support/users/46664/)
 * (@46664)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249019)
 * and if i drop it my other blog is affected. as i said its a multiple blog with
   each its own database.
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249022)
 * You are using the same database ?
    Can you create another ?
 *  Thread Starter [46664](https://wordpress.org/support/users/46664/)
 * (@46664)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249024)
 * i did create a new database. and im importing the database from the other blog
   to the newly installed blog..im still in the same site. its a multi installation
   and each have its own database.
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249028)
 * Have you installed WP, and now you want the posts and everything else ? If so,
   that will cause the error.
 * Assuming the place you are moving the posts to is new, use phpmyadmin and DROP
   all the tables. Then an import will proceed without issue. If you aren’t sure
   about that, there is a guide on the site I linked above.
 *  [Ming](https://wordpress.org/support/users/ming/)
 * (@ming)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249030)
 * The problem is that the posts from each separate install will have used the same
   ID numbers. And since the ID field requires unique values you’ll get errors importing.
   Maybe someone could write a script or query to bump ID’s in one database up by
   1000 or so.
 * This will create a problem for bookmarks if you’re not using permalinks.
 *  [Ming](https://wordpress.org/support/users/ming/)
 * (@ming)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249033)
 * Sorry, I assumed you had two currently running blogs you were combining into 
   one. If you’re just moving one blog into another DB then Podz is on the right
   track. Still, if there are posts in both blogs you’ll need to confirm that their
   ID numbers don’t over lap.

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

The topic ‘data copy’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 8 replies
 * 3 participants
 * Last reply from: [Ming](https://wordpress.org/support/users/ming/)
 * Last activity: [20 years, 9 months ago](https://wordpress.org/support/topic/data-copy/#post-249033)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics