Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.