This will take some explaining, but I'll be as clear as I can:
I'm trying to export my database so I can switch to a new host (WordPress to WordPress). My current host is a friend's server, but I think it's time to move to a paid hosting situation.
I was running a very old version of WordPress (1.5), but when I tried to upgrade, I discovered that my friend is running an old version of MySQL. I downgraded back to 2.0, but I got a lot of errors in reading the Categories. So I went back to 1.5, which looks fine on the blog itself.
The problem is when I try to export, using the export plug-in. This is the error message I get:
Please choose the categories you wish to export.
WordPress database error: [Unknown column 'category_count' in 'field list']
SELECT cat_ID, cat_name, category_nicename, category_description, category_parent, category_count FROM wp_categories WHERE cat_ID > 0 ORDER BY cat_name
Warning: Invalid argument supplied for foreach() in /usr/home/web/parenthetical.net/wp-content/plugins/wp-xmlmigrate.php on line 30
This error means I can't export the xml file.
I've been using this blog for three years. If I started from scratch I'd lose literally hundreds of posts and comments. I'm at a total loss -- all I want is a) a functional blog, and b) not to lose all my previous work! Any help you can provide would be fantastic!