Black Hat Forum Black Hat SEO The only backlink provider with unlimited projects/links per day!
Go Back   Black Hat Forum Black Hat SEO > Black Hat SEO > Blogging

Blogging Talk about Wordpress, Blogger, and other blogs.
Blogs = Increased Spider Visits.

Mad Content   BLOG SEO
Search
 
LinkWheel

LiveChatAgent



Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-19-2010, 11:34 AM
thesuvo's Avatar
Registered Member
 
Join Date: Feb 2010
Location: India
Posts: 78
Thanks: 5
Thanked 18 Times in 8 Posts
Reputation: 6
iTrader: (0)
Unhappy How to Retreive Posts in Wordpress from another WP DB

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-19-2010, 11:39 AM
Junior Member
 
Join Date: Mar 2010
Posts: 129
Thanks: 11
Thanked 11 Times in 10 Posts
Reputation: 9
iTrader: (0)
Default Re: How to Retreive Posts in Wordpress from another WP DB

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-19-2010, 12:23 PM
mark9510's Avatar
Regular Member
 
Join Date: Feb 2009
Location: New York
Posts: 311
Thanks: 13
Thanked 34 Times in 23 Posts
Reputation: 14
iTrader: (0)
Default Re: How to Retreive Posts in Wordpress from another WP DB

There should be a table called Wp_posts just copy that table over to the Wp_posts on your new domains database
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 03-19-2010, 01:21 PM
Junior Member
 
Join Date: Mar 2010
Posts: 129
Thanks: 11
Thanked 11 Times in 10 Posts
Reputation: 9
iTrader: (0)
Default Re: How to Retreive Posts in Wordpress from another WP DB

What if I need to copy from someone elses wordpress blog?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 03-19-2010, 02:18 PM
thesuvo's Avatar
Registered Member
 
Join Date: Feb 2010
Location: India
Posts: 78
Thanks: 5
Thanked 18 Times in 8 Posts
Reputation: 6
iTrader: (0)
Default Re: How to Retreive Posts in Wordpress from another WP DB

Quote:
Originally Posted by Kvamme View Post
What if I need to copy from someone elses wordpress blog?
I think for that you need to have the access to his db.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 03-19-2010, 02:21 PM
thesuvo's Avatar
Registered Member
 
Join Date: Feb 2010
Location: India
Posts: 78
Thanks: 5
Thanked 18 Times in 8 Posts
Reputation: 6
iTrader: (0)
Default Re: How to Retreive Posts in Wordpress from another WP DB

Quote:
Originally Posted by mark9510 View Post
There should be a table called Wp_posts just copy that table over to the Wp_posts on your new domains database
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 03-19-2010, 03:12 PM
Newbies
 
Join Date: Mar 2010
Posts: 24
Thanks: 4
Thanked 6 Times in 6 Posts
Reputation: 3
iTrader: (0)
Default Re: How to Retreive Posts in Wordpress from another WP DB

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Tags
wordpress

Backlinks Genie

SE Nuke



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Q. About Displaying Certain Posts in Wordpress therat Blogging 3 01-31-2010 10:14 AM
Wordpress Scheduled Posts And SEO B*Dogg Blogging 2 11-03-2009 09:31 PM
WordPress blocking my posts??? Sharkattack Link Building 3 10-05-2009 03:37 PM
30-50 wordpress blog posts a day c0ntenth|ef Blogging 7 07-15-2009 10:44 PM

SEO Paladin


Web Hosting
Copyright © 2005 - 2012 BlackHatWorld.com All rights reserved.