moved domains, new wp install (14 posts)

  1. mishku
    Posted 11 years ago #

    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!

  2. Jinsan
    Posted 11 years ago #

  3. mishku
    Posted 11 years ago #

    Yes I have actually followed that guide... I had two attempts at doing this, the first one failed (due to my own illogical stupidity).

    The second attempt was by following that guide and the reason that guide doesn't help me much is because I don't want to move my whole blog - only the posts, comments, and categories. Nothing else. Not the layout I currently have, or any of my subpages.

    I used that guide a few days ago to move my best friends blog from one sub folder of my domain name to another, and that worked no problem - but moving only posts across seems to be a problem.

  4. moshu
    Posted 11 years ago #

    mishku, it doesn't work like that... moving only tables the YOU think are inportant! For WP to work properly follow exactly what tutorial says. The database will NOT move the layout, only the content and everything else that is necessary for WP to work.

  5. Jinsan
    Posted 11 years ago #

    well i have to get up in the morn it's like 1.30am here nearly. Try this thread:


    Does it help at all? What about the post above regarding referer headers?

    Here's a few other related topics:


    Hopefully someone can look at the subject better and provide a more full answer. But it seems like you've moved part of it and not all of it which is why you see those errors. You need to install WP properly THEN move the data over


  6. mishku
    Posted 11 years ago #

    yeah I gathered that from my first futile attempt - I thought I could outsmart WP - HOW WRONG I WAS!!!

    Then I went back, started again, and followed the tutorial and it also failed and is now giving me this error when I try to go to the website - Warning: Invalid argument supplied for foreach() in /home/mishkuco/public_html/wp-settings.php on line 113

  7. Jinsan
    Posted 11 years ago #

    what's on line 113 of that file?

  8. mishku
    Posted 11 years ago #

    foreach ($current_plugins as $plugin) {

    maybe it's because I had some kind of plug in on my old WP install? could that be the problem?

  9. mishku
    Posted 11 years ago #

    here is the thing right - I don't want to move my WP installation. I just want to move the database to a brand new install... the guide keeps referring to moving all the files and folders in my current installation... What I am trying to achieve - is this even possible?

  10. Jinsan
    Posted 11 years ago #

    yes because when you download the database you're downloading your posts and nothing else - no layouts, no graphics ONLY the posts.


    Try that, backup your original date ( I hope yous till have it) then follow the restore guide after you've backed up and restore it to your new install.

  11. mishku
    Posted 11 years ago #

    ok, I backed it up, went into my php admin on my new host... follow the steps....

    however, when I select the file I want to restore, and click "go" it says the following: MySQL said: Documentation
    #1050 - Table 'wp_categories' already exists

    do I need to remove the new empty tables from the WP install before restoring?

  12. mishku
    Posted 11 years ago #

    update: I have moved the database to my new install... but when I go to mishku.com nothing comes up. I am able to login into wp admin however on some sections in tends to be buggy.

    I have moved WP installs before, I can't see what I have done wrong.

  13. moshu
    Posted 11 years ago #

    Was the WP used with the imported database the same version as in the new install? If not, you have to run the upgrade.php.

  14. techwench
    Posted 11 years ago #

    And, if the database is still thinking you're using the old theme, you'll have to swap that out also.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.