WordPress.org

Ready to get started?Download WordPress

Forums

data copy (9 posts)

  1. 46664
    Member
    Posted 8 years ago #

    i have a mulitple blog installation.now how can i copy my posts and comments to the other blog wihtout messing up?

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    Export the database, then re-import it.
    That's about it really...
    http://www.tamba2.org.uk/wordpress/move2/

  3. 46664
    Member
    Posted 8 years ago #

    thats exactly i did and i get error importing because it says that its already exists.

  4. 46664
    Member
    Posted 8 years ago #

    and if i drop it my other blog is affected. as i said its a multiple blog with each its own database.

  5. Mark (podz)
    Support Maven
    Posted 8 years ago #

    You are using the same database ?
    Can you create another ?

  6. 46664
    Member
    Posted 8 years ago #

    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.

  7. Mark (podz)
    Support Maven
    Posted 8 years ago #

    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.

  8. Ming
    Member
    Posted 8 years ago #

    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.

  9. Ming
    Member
    Posted 8 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags