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.

 

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

 

There should be a table called Wp_posts just copy that table over to the Wp_posts on your new domains database

 

What if I need to copy from someone elses wordpress blog?

 

I think for that you need to have the access to his db.

 

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.

 

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