I have just bought a new hosting package and a new domain name, which I have already installed WP on.
Now all I want to do is move my posts and my comments over to my new WP database... I don't want to move my old layout, only the posts, comments, categories. I moved 5 database tables:
which seems to me the important ones.
Now, when I go to my new domain (mishku.com, for reference the old one is digital-rebel.net) everything works fine, however, when I try to post a new entry it spits out some nasty errors at me:
WordPress database error: [Unknown column 'menu_order' in 'field list']
INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, post_modified, post_modified_gmt, post_parent, menu_order) VALUES ('198', '1', '2005-05-31 05:18:43', '2005-05-30 23:48:43', 'crap', 'new', '', 'publish', 'open', 'open', '', 'new', '', '2005-05-31 05:18:43', '2005-05-30 23:48:43', '0', '0')
Warning: Cannot modify header information - headers already sent by (output started at /home/mishkuco/public_html/wp-includes/wp-db.php:98) in /home/mishkuco/public_html/wp-admin/post.php on line 153
WordPress database error: [Unknown column 'guid' in 'field list']
UPDATE wp_posts SET guid = 'http://mishku.com/?p=' WHERE ID = '198'
What have I done wrong? Or what haven't I done? Please help!