I think you would be better taking a complete 2.0.7 blog, upgrade that to 2.1 then in the Admin panels, delete what you don’t want.
Addtional Resources:
Upgrading WordPress
Moving WordPress
Ye, I know there are better ways to upgrade, but i need this solution for a good reason. Don’t even ask 🙂
What actually needed is to know what changes has been made in these tables and update it accordingly..
I don’t know SQL well unfortunately…
Okay, I don’t ask.
There may be a way to accomplish your task but it’s not easy and involves in depth knowledge of WordPress and SQL. So based on your skills I would recommend: Don’t even ask 🙂
Well.. That’s why i’m looking for someone with indepth knowledge of WordPress and SQL to help me figure it out….
I do not guarantee any of these will work, so don’t cry if your dog dies from this…
UPDATE wp_posts SET post_status = ‘published’, post_type = ‘page’ WHERE post_status = ‘static’
UPDATE wp_posts SET post_status = ‘inherit’, post_type = ‘attachment’ WHERE post_status = ‘attachment’
ALTER TABLE wp_categories ADD link_count BIGINT , ADD posts_private TINYINT , ADD links_private TINYINT
Manually change the status to ‘future’ for any future posts.
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘UPDATE wp_posts SET post_status = ‘inherit’, post_type = ‘attach
Any idea ?
