Hey Z,
I see that your post is three month old so I guess that you are maybe not that interested in my solution by now. But if anybody else finds this post, he or she may have a use for my workaround 🙂
I had the same problem today and what worked for me was this:
1. in the database of the old blog: instead of exporting the whole wp_posts-table as a file I unchecked “send” in the export-dialogue, clicked “ok” and thereby received the SQL-statements for the table.
2. I copied only the SQL-statements for the table structure but not the statements for the table data, i.e.
CREATE TABLE IF NOT EXISTS wpsj_posts (
ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_author bigint(20) unsigned NOT NULL DEFAULT ‘0’,
post_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_date_gmt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content longtext NOT NULL,
post_title text NOT NULL,
post_excerpt text NOT NULL,
post_status varchar(20) NOT NULL DEFAULT ‘publish’,
comment_status varchar(20) NOT NULL DEFAULT ‘open’,
ping_status varchar(20) NOT NULL DEFAULT ‘open’,
post_password varchar(20) NOT NULL DEFAULT ”,
post_name varchar(200) NOT NULL DEFAULT ”,
to_ping text NOT NULL,
pinged text NOT NULL,
post_modified datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_modified_gmt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content_filtered text NOT NULL,
post_parent bigint(20) unsigned NOT NULL DEFAULT ‘0’,
guid varchar(255) NOT NULL DEFAULT ”,
menu_order int(11) NOT NULL DEFAULT ‘0’,
post_type varchar(20) NOT NULL DEFAULT ‘post’,
post_mime_type varchar(100) NOT NULL DEFAULT ”,
comment_count bigint(20) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (ID),
KEY post_name (post_name),
KEY type_status_date (post_type,post_status,post_date,ID),
KEY post_parent (post_parent),
KEY post_author (post_author)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=294 ;
into the SQL command-line window of the database of the new blog.
3. I used the WordPress tool “export data” in my old blog to download an xml-file with all posts and articles in it .
4. I used the WordPress tool “import data” with this xml-file to import all posts and articles into my new blog.
5. I was pleased to see that these steps resulted in a working wp_posts database table and noticed that this new table was considerably shorter than the old table (2 pages instead of 9) but had all articles and pages in it.
I hope this helps 🙂
