We've just finished redesigning a blog that has almost daily posts.
Over the past month that we were redesigning it, there have been a large number of new posts that now need to be reincorporated into the database before we deploy the new site.
To get these new posts and upload them into the new site's database, what is the procedure? My guess is that we need to:
- Export a sub-section of wp_posts and then import that into the new site.
- Download recent content from wp-uploads and upload that into the same directory in the new site.
So when I'm exporting that most recent sub-section of wp-posts, what is the procedure to follow? And how do I coordinate that with the corresponding records in the wp_postmeta table?
Are there any other tables that need to be exported as well?