Archiving Your Old Posts Onto A Separate Site


We recently had a client come to us with a unique request, and I thought I’d break down the process for anyone else in a similar circumstance.

The client runs a very popular football blog that started in 2006. Over the past 6.5 years, they’ve accumulated 20K posts, 120 categories, 7100 tags, and over 6800 comments. As you can imagine, their WordPress database was HUGE!

When upgrading to a new theme, the site became extremely slow, to the point that we had to revert to the original theme. The issue was that 25GB database..

After talking it over with their team, we decided to create an Archive site which held all the old posts (, so that people searching for that old content would be able to still access it. That meant exporting the database (through a shell script, since the DB was so large), and then downloading all of the files associated with the site. Once that was done, we created the new site, imported the database, changed all of the references to through MySQL, and then uploaded all of the backed-up files.

To make sure that Google was redirecting people to the Archive site, we had to edit the .htaccess file and setup some redirection rules. This turned out to be really easy, since their old Permalink structure included the date and year. So 6 redirection rules (one for each year) and we were done!

The new site uses a cleaner permalink structure (, and we laid out a category structure for them moving forward.

All in all, it was a VERY stressful few days, but in the end everything is running great and the client is extremely happy.

Want us to handle your migration project? Contact us for a free quote!

Enjoyed this post?
Subscribe to Zander Chance via RSS Feed or E-mail and receive daily news updates!

Submit to Digg  Stumble This Story  Share on Twitter  Post on Facebook  Post on MySpace  Add to  Submit to Reddit  Fave on Technorati

One Response to “Archiving Your Old Posts Onto A Separate Site”

  1. Zander says:

    I’ll also be posting a follow-up story that talks about doing your research before purchasing a premium theme.

    Needless to say, our client had a few unexpected surprises. One was big enough that we have to now hack into the code and fix it, since the author basically told us “it’s not included in the theme”..

Leave a Reply