WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to export the last two week's worth of blog posts from one site into another site, including all meta data and post author info.

Is there a good SQL statement to do this, or a plugin that will help me accomplish this?

share|improve this question
up vote 1 down vote accepted

The native import/export tool can do most of this, though I don't think it will grab all the author profile information (not sure on that - I know it doesn't bring over passwords, but it might bring the rest). In the WP admin panel go to Tools > Export and walk through the various option screens. Best of luck!

share|improve this answer
I guess they have improved that since the last time I've looked. Any thoughts as to if it preserves what the permalink should be? I want to ensure an almost exact replication, including URLS. – Dan Gayle Jul 7 '11 at 22:02
Yes, I believe it preserves the slug/permalink, though it will obey the settings of the new site. In other words if the old site used /%month%/%postname% and the new one uses /%month%/%day%/%postname% it will obey the new permalink structure. But the postname / slug will remain the same. – Michelle Jul 8 '11 at 15:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.