How to mix two wordpress databases

Discussion in 'Blogging' started by maxmed, Nov 26, 2010.

  1. maxmed

    maxmed Registered Member

    Joined:
    Jan 21, 2009
    Messages:
    53
    Likes Received:
    1
    Hi,

    I have two articles wordpress databases and I want to mix them into one.How it could be done ?????


    Thanks
     
  2. laddermatch

    laddermatch Newbie

    Joined:
    Nov 27, 2010
    Messages:
    13
    Likes Received:
    2
    You'll need to be clearer about what you're looking for here. Do you mean showing the posts from both databases on a single website?
     
  3. maxmed

    maxmed Registered Member

    Joined:
    Jan 21, 2009
    Messages:
    53
    Likes Received:
    1
    Yes , i want the posts from both databases to show in a single website .Thanks
     
  4. extremephp

    extremephp BANNED BANNED

    Joined:
    Oct 19, 2010
    Messages:
    1,293
    Likes Received:
    1,276
    Keep the 1st DB intact.

    Extract Post and Category table from the second as a zip.

    Import it to the first.

    Done :)

    P.S : Trial And Error! Be ready for that!

    ~ExP~
     
  5. elocin

    elocin Regular Member

    Joined:
    Oct 26, 2010
    Messages:
    308
    Likes Received:
    87
    Go the back end of your wordpress site.... yourdomain.com/wp-admin

    Go to the tools section and click export. It will give you a .xml file....

    Go to the back end of the new wordpress site. Tools/import.
    Import that xml file and you're done!