Forums

The WordPress MU forums have moved to the MultiSite forum on WordPress.org

From multiple installations of WordPress to a single MU (5 posts)

  1. garyploski
    Member
    Posted 2 years ago #

    Good day all.

    I have three WP blogs that I plan to import into a MU. I ran a test installation and found that by importing the WP export file a number of things were not included. My primary concern is the wp_options table.

    Am I missing something simple that will allow me to import the basic settings (not the plugin options) so I do need to go through each blog settings page and re-check every option?

    One Example: Start of week defaults to 1 in MU but I have it set to 0 in one WP installation.

    I tried importing a set of wp_options from one blog into the MU install and found a number of entries overwritten that should not have been and/or will likely cause trouble when I begin using the blog.

    Example: The location where files are uploaded to in a WP blog is /wp-contents/ while in MU it relates to the blog # (1, 2, 3, etc.)

    Thanks in advance for any suggestions and/or ideas.

  2. andrea_r
    Moderator
    Posted 2 years ago #

    Nope, the export file doesn't get the wp_options table.

    You may want to just export that table, rename it with the new blog's ID number in there wp_3_options for example) and stuff it in the new db.

    And yep, the image file locations are different.

    http://bavatuesdays.com/importing-a-single-wp-blog-to-a-wpmu-installation/

  3. garyploski
    Member
    Posted 2 years ago #

    THanks andrea_r.

    That was my most recent attempt. It seemed to work properly but I noticed a number of entries in the MU wp_options were missing after I imported an abbreviated sql file.

    Alas.

    I don't know if an developers are interested in considering this but it will definitely impact a number of people considering a move from multiple single installs to a MU install. I say this because of what Matt said during the latest State of WP at the annual event (in San Fran?)

    The bavatuesdays post looks great and will be very helpful. I saw in the comments how people without experience with sql or phpmyadmin were having difficulties. Yet another reason the developers may want to consider the relationship of a single install of WP to MU.

    Just a thought and possibly in development already. I'm new to MU which means I'm probably behind the curve. Trying to catch up though.

  4. andrea_r
    Moderator
    Posted 2 years ago #

    I'm sure they're taking these things under consideration with the upcoming merge. :)

    "I noticed a number of entries in the MU wp_options were missing after I imported an abbreviated sql file"

    Could've been many things:
    - user error :)
    - different single WP and MU version
    - lost text in the transfer

  5. garyploski
    Member
    Posted 2 years ago #

    I'll keep my fingers crossed andrea_r. =)

Topic Closed

This topic has been closed to new replies.

About this Topic