After truedeath.com was constantly bombarded with spam comments, I decided that enough was enough. I backed up the database and erased everything. After installing everything again and with new spam-tastic measures in place, the cleanliness of the blog was a fresh breath of clean air.
But 1 month into blogging on a new installation, I realise that I'd like to somehow bring back the old posts somehow.
I've backed up both databases old and new and have phpmyadmin running on my computer to test things out before I try anything on the live server.
Does anybody know how I can go about doing this? I tried moving the wp_posts table from OLD to the NEW one using phpmyadmin but since there is a clash in the autonumbering of the posts, this is not possible. There is no conflict with the authors as everything is as it was before. I am only interested in porting over the posts.