I've got a challenge for those of you who consider yourselves to be WordPress wizards...
My client inherited a (badly designed) web site running on WP 2.8.5. I'm redesigning the site and putting WP 2.9.2 behind it. Her current site uses an elaborate hierarchy of categories and posts. I've been able to duplicate the hierarchy but hit a brick wall when trying to figure out how to get the content from her current site to the new one. Her wp_posts table has about 6,000 rows, although many are "post revisions". I think in reality there are about 1,200 actual posts spread among about 120 categories.
I can't do the WordPress export / import dance because I think it will break a lot of stuff I've got set up for the new site. I really just need to transfer the posts data and don't want to mess with anything else. I've tried doing a raw SQL table export, thinking I could tweak a few things then do a bunch of SQL "INSERT"s on the new site. But there seem to be some wp_posts table changes between 2.8.5 and 2.9.2, plus I think there may be some foreign keys that won't get set up correctly.
I hate the thought of having to manually re-enter all the content, post by post. Even if it took only one minute to do each one, I'd need about 20 hours to get everything in there. There's got to be a better way, right? (Please?)
Does anyone have any clever ideas on how I can do this other than brute force?