moved domains, new wp install

  • mishku

    (@mishku)


    18 years, 11 months 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:

    wp_categories
    wp_comments
    wp_post2cat
    ws_postmeta
    wp_posts

    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!

Viewing 13 replies - 1 through 13 (of 13 total)
  • jinsan

    (@jinsan)

    18 years, 11 months ago

    have you followed this guide?

    http://www.tamba2.org.uk/wordpress/move/

    For referers try:

    http://codex.wordpress.org/Enable_Sending_Referrers

    and this recent thread:

    http://wordpress.org/support/topic/34582

    Thread Starter mishku

    (@mishku)

    18 years, 11 months 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.

    moshu

    (@moshu)

    18 years, 11 months 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.

    jinsan

    (@jinsan)

    18 years, 11 months ago

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

    http://wordpress.org/support/topic/24966#post-140479

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

    Here’s a few other related topics:

    http://wordpress.org/support/topic/24742
    http://wordpress.org/support/topic/24090#post-136107

    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

    Cheers

    Thread Starter mishku

    (@mishku)

    18 years, 11 months 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

    jinsan

    (@jinsan)

    18 years, 11 months ago

    what’s on line 113 of that file?

    Thread Starter mishku

    (@mishku)

    18 years, 11 months 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?

    Thread Starter mishku

    (@mishku)

    18 years, 11 months 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?

    jinsan

    (@jinsan)

    18 years, 11 months ago

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

    http://www.tamba2.org.uk/wordpress/backup/

    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.

    Thread Starter mishku

    (@mishku)

    18 years, 11 months 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?

    Thread Starter mishku

    (@mishku)

    18 years, 11 months 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.

    moshu

    (@moshu)

    18 years, 11 months 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.

    techwench

    (@techwench)

    18 years, 11 months ago

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

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘moved domains, new wp install’ is closed to new replies.