1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to Retreive Posts in Wordpress from another WP DB

Discussion in 'Blogging' started by thesuvo, Mar 19, 2010.

Tags:
  1. thesuvo

    thesuvo Registered Member

    Joined:
    Feb 3, 2010
    Messages:
    82
    Likes Received:
    18
    Location:
    India
    Home Page:
    Hello,
    I have a unique problem. I had a website with co.cc but due to some reason they blocked that domain. I'm earning quite well from that site and i want to get back my contents.

    I don't have access to the posts of the site but i have the DB of that site. I want to know if anyone can tell me how can i insert those post into my new DB.

    I tried to extract the post content by running SQL command but failed as it has more than 2000 Posts and it is not possible to import manually.

    Both of the sites are Wordpress sites.

    Please BHW guys help me.
     
  2. Kvamme

    Kvamme Junior Member

    Joined:
    Mar 19, 2010
    Messages:
    128
    Likes Received:
    12
    I also need to know how to copy someone elses wordpress blog word by word and title by title into my blog at the same time donot copying unnecessary adsense ads running in this website,if anyone can help it will be great
     
  3. mark9510

    mark9510 Regular Member

    Joined:
    Feb 7, 2009
    Messages:
    309
    Likes Received:
    36
    Occupation:
    A Kid Making Money Off The Web
    Location:
    New York
    There should be a table called Wp_posts just copy that table over to the Wp_posts on your new domains database
     
  4. Kvamme

    Kvamme Junior Member

    Joined:
    Mar 19, 2010
    Messages:
    128
    Likes Received:
    12
    What if I need to copy from someone elses wordpress blog?
     
  5. thesuvo

    thesuvo Registered Member

    Joined:
    Feb 3, 2010
    Messages:
    82
    Likes Received:
    18
    Location:
    India
    Home Page:
    I think for that you need to have the access to his db.
     
  6. thesuvo

    thesuvo Registered Member

    Joined:
    Feb 3, 2010
    Messages:
    82
    Likes Received:
    18
    Location:
    India
    Home Page:
    Yes there is a table wp_post but will it work if i copy it. I'm asking bcoz each post must needs its meta desc too.
     
  7. Twats

    Twats Newbie

    Joined:
    Mar 14, 2010
    Messages:
    24
    Likes Received:
    6
    damn, don't you know what a search and replace function is? just make a fresh blog, and import that DB into that new blog. before importing open your sql file in notepad++, search for the old domain and replace with the new one. then import it! the easiest way. after importing, export the WP xml and import into any other blog.

    hope this helps