asked on

Easy Wordpress MySQL question to export posts ONLY from a database and import into a new database

Hi,
I would like to export the posts from an old wordpress site. I only want the posts, and I want them to override the ones in my new site. So what do I do in MySQL to export the old posts and then import them into the new table.
Is is as simple as selecting the table and then importing it into the new wordpress site. I don't want to mess anything on the new site (except the posts of course@)
I hope someone can help me do this one please?
Thank you,
A

HainKurt

it depends on what module you are using...

if old and new site are using same template/modules, probably, you can just export from old mysql and import into new one...

you need to check your db and find where and how they are stored...
maybe it is not just one table, but multiple tables... who knows...

Amanda Watson

ASKER

hmm, it is a newer wordpress site, but essentially they are the same table, so I would have to think you are just replacing the existing new db of posts with a new table?

HainKurt

applications may create multiple tables in the db with some relations...
I dont think it is just a plain simple table :)
if you are lucky, it will be in just one table, but I dont think so...
what plugin is that? maybe there are some documentation somewhere...

ASKER CERTIFIED SOLUTION

David Favor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Amanda Watson

ASKER

Thansk, this was what we did