I’m going to show you how to export sections of a large wordpress site, since we’re talking about plugins this week. This blog is pretty large now with hundreds of posts and thousands of comments. I get 20-30 comments daily, even when I don’t post a thing. The database is getting pretty big, even though I routinely clean it out and trim it down – it continues to grow.
There are many reasons you may need to export your wordpress database – and one is backup. Maybe you’ve been writing for many years, and want to permanently archive everything more than 2 years old. You could even want to export only things by a certain author, in a certain category, or only all your old drafts. WordPress has an export function, but the only option it currently has is to restrict by “author”. You can’t limit the export by any other criteria.
Check out Advanced Export for WordPress and WPMU:
As you can see in the image, you can selectively export sections of your blog at a time, and then “import” them to another (or the same) blog. You could export an entire category and then delete all those posts from your blog, or you could move them to a completely new site. Maybe you run a multi-author blog and somebody wants a copy of everything they wrote over time. You could even archive all your posts for an entire year in one file.
This export plugin is great, just remember that it’s only for posts. If you want to learn how to export and import a very large wordpress database (including all settings, pages, posts, comments, etc), one of my earlier posts might be better suited for you: “How to Import and Export Very Large MySQL Databases“.
It seems there are WP plugins to do whatever you can dream of wanting to do with a blog. To me, this particular one seems somewhat limited in scope though. I can’t really see great value in exporting some of the posts when you’re much better off exporting everything all at once.
.-= Driver Genius´s last blog ..Driver Genius – Professional Driver Management =-.
Thanks a lot for posting this! I’ve been having the same problem as you do: managing a huge database has turned almost impossible. Now, I’ll try your tips but I’m sure you’ve saved my life almost!
.-= Monica´s last blog ..FUN AT BOCA CHICA =-.
OK, thanks for the tip. I may have to install this just to try it!
First of all Congo for great blogging success you getting high volume of feedback from readers and it become helpful for us to learn how to export those data thx again.