I have large DB of blog post I already export it by year and wanted to make archive by year doing it on subdomain, like 2012.mysite.com I stack looking for solution on internet, I wondering if their are someone done this before? and can advise me a good solution, all I wanted is to separate to another db by year for archiving.
I have a knowledge in PHP and MYSQL.