Two DataBases (4 posts)

  1. cold0zero
    Posted 11 years ago #

    i have two web site eche one have a wordpress and database

    now i want to merging the to data base to be one site and on data base without lose any topic

    can i do that :)

  2. Cypher
    Posted 11 years ago #

    The table you are most interested in is "wp_posts" and you can bring over the posts from one database to the other, but have to make sure that you don't retain the ID from the second database. It is entirely likely that the ID's will have been re-used.

    That is, you will have posts on both websites with ID of 1, 2, 3 and so on, depending on how many posts you have on each website.

    You will need to learn a little bit about MySQL queries to import the data without the ID as well.

    It can most definitely be done with a little care.


  3. cold0zero
    Posted 11 years ago #

    can you give me a link about :: MySQL queries to import the data without the ID

  4. Kafkaesqui

    Posted 11 years ago #

    You would have to export the table as a text (sqldump) file, edit out the IDs in the INSERT lines (that is, replacing them with '' (empty single quotes), and import that.

    Serious warning: These posts, once (if?) successfully imported, will not have associated categories, custom field data you may have assigned them, original comments, and even the author may not be correct (if they're different user ID's between databases). What you're attempting is not easy, and risky if you don't know what you're doing.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.