Migrating Your Current WordPress Blog to a WordPress Multisite Blog

Author Bernard Peh at SitePoint has posted a follow-up to his Multisite WordPress tutorial. This time, he’ll show you how to migrate an existing standalone blog into your new multisite setup.

The first thing to do is make some preparations.

Make sure you have the latest version of WordPress installed: we’re up to version 3.1 now. This is important for consistency between installations and also to ensure you have access to the multisite feature. Upgrade WordPress if necessary and ensure the multisite feature is enabled. Check the previous video for details.

Back up all databases for both multisite and singlesite.

Do not activate domain mapping for newsite yet.

This is a good time to do a bit of housekeeping and remove all old spam comments, expired users and unwanted posts on singlesite. You will reduce unwanted content and make your life a little easier later on.

Copy the theme and plugins from singlesite to multisite. How you achieve this depends on how your sites are hosted. You may need to use cPanel or similar, or stand alone FTP.

The next step is to export the content of singlesite to a downloadable file. In the singlesite WordPress admin panel under Tools in the left sidebar, click on Export. Click on the Download Export File button to export the content of the site to an xml file.

Switch your attention to the newsite WordPress installation. To import the singlesite xml file we have just exported, we need to install a plugin. Click on Add New under Plugins in the left sidebar of the admin panel and search for the term “WordPress Importer”. Follow the instructions to install that specific plugin.

Then go to Tools / Import, click on WordPress and upload the singlesite export xml file. Proceed with the import only up to the Assign Authors page.

At this point, you’re given the option to map the authors from singlesite to newsite. This is the most challenging part of the process because WordPress does not allow you to have duplicated authors across different sites in your multisite, so you need a way to identify and resolve the duplicate authors.

To do this, you can compare author usernames and email addresses.

Go to phpMyAdmin for the singlesite database. Duplicate the wp_users table, call it wp_users_tmp and then export this table. Then switch to the multisite database and import wp_users_tmp.

To compare the wp_users table from both databases, run this query on the multisite database to give us a list of all email duplicates.

SELECT t.user_login as singlesite_user, w.user_login as multisite_user, w.user_email
FROM wp_users w, wp_users_tmp t WHERE w.user_email = t.user_email

Now run this query to check for any username duplicates.

SELECT t.user_login as singlesite_user, w.user_login as multisite_user, w.user_email
FROM wp_users w, wp_users_tmp t
WHERE w.user_login = t.user_login and w.user_email != t.user_email

Back on the Assign Author page in the multisite import process, append “_singlesite” or another unique identifier to the existing singlesite username for any case where a user is duplicated.

Check the Download and import file attachments checkbox and click Submit.

Since all users now have unique names, you can compare them against the profiles you have in singlesite. Now, you can manually enter their profile details in the users section.

Re-activate all the plugins and re-setup the widgets in newsite. You can also configure the theme under Superadmin / Sites.

Point your browser to http://multisite.something/newsite/ and check that newsite now holds the content of the singlesite.

Change the IP address of the singlesite domain to point to your multisite host.

Add the singlesite domain as the primary domain under Superadmin / Domains.

Read More:


WordPress 3.1 is now available

WordPress 3.1 is now available for download or you can update from within your dashboard.

Named “Reinhardt” in honor of the jazz guitarist Django Reinhardt, this release features a lightning fast redesigned linking workflow which makes it easy to link to your existing posts and pages, an admin bar so you’re never more than a click away from your most-used dashboard pages, a streamlined writing interface that hides many of the seldom-used panels by default to create a simpler and less intimidating writing experience for new bloggers (visit Screen Options in the top right to get old panels back), and a refreshed blue admin scheme available for selection under your personal options.

There’s a bucket of candy for developers as well, including our new Post Formats support which makes it easy for themes to create portable tumblelogs with different styling for different types of posts, new CMS capabilities like archive pages for custom content types, a new Network Admin, an overhaul of the import and export system, and the ability to perform advanced taxonomy and custom fields queries.

With the 3.1 release, WordPress is more of a CMS than ever before.

More Info at:

Migrating from WordPress.com to WordPress.org

Transitioning from WordPress.com to WordPress.org involves several steps, but the most important move to make a WordPress.org installation to maintain the look and functionality of an older WordPress.com site comes via plugins.

WordPress.com includes some built-in features that aren’t included in a standard WordPress.org installation, and you must recreate them by installing a series of plug-ins such as:

  • WordPress.com Stats — This will give you the same kind of stats on WordPress.org that are available to WordPress.com users.
  • VideoPress — If you have ever paid for the VideoPress video upgrade, this plugin will bring the same functionality (and access to your VideoPress videos) to WordPress.org.
  • Wickett Twitter Widget — This is the same widget WordPess.com uses to display tweets in the sidebar of a blog.
  • Grunion Contact Form — This plugin was used as the basis of the new Contact Form feature in WordPress.com.
  • PollDaddy — This plugin will enable any polls created in WordPress.com.

There’s much more to the transition. Christina Warren from Mashable has written a very useful article that you can read here:

She also walks through the process of migrating a blog on WordPress.com to WordPress.org on a video that you can view here:

And of course, WordPress.com also has an article explaining how to migrate a Blog  that you can read here:

Publicize from WordPress.com

Publicize” is a WordPress.com feature that allows you to send your blog posts to several places at the same time you hit the “Publish” Button.

By default all posts that you create in WordPress.com end up on global tag pages and are sent out to many search engines via Ping-o-Matic!, while sitemaps pings notify several search engines of new updates.

Now, in addition to these built in features, you can also choose to send your posts to several third party services. Currently, WordPress.com Publicize supports Messenger Connect, Facebook, Twitter, and Yahoo!. This very post is also a test of the Publicize feature, so it should be appearing at all those Social Media outlets.

Apparently a mention to activate the Publicize feature is now supposed to show somewhere on the top part of the “Edit” screen, but for some reason it’s not showing in my browser. In any case you can turn on the publicize feature, go to the Sharing Settings page in your Dashboard. Here you can configure any of the Publicize services you like.


To choose what Publicize services you want for a specific post, just click the Publicize Edit link and uncheck those services you want.

You can also customize the message that gets sent by typing it in to the Custom Message box after you click the Publicize Edit link.

If you have more questions, you can read more about how Publicize works here

WordPress made for humans

Stefanos Kofopoulos: WordPress made for humans. The space in between SEO and usability greatness

Stefanos Kofopoulos is a full time blogger, social media weirdo, event organizer, entrepreneur, dreamer, the man you hate or madly love.

WordPress & bad boy for life

Learn WordPress

Go from blogging zero to blogging hero in 10 quick levels.

Learn WordPress is a step-by-step tutorial that includes lessons on how to start a blog, customize your site, and connect with other bloggers in the WordPress.com community.

Here’s a video tutorial to get you started:

More info on how to get started at the following page:

You can also have all of the pages in one giant page, so you can print out the entire thing — today it’s about 66 pages.
Click here for a printer-friendly version of the entire Learn WordPress.com tutorial.

The anatomy of a WordPress theme

Joost de Valk has created the infographic below just to remind us what a normal WordPress theme looks like.

Check out his Anatomy of a WordPress theme:


This infographic was created by CreditLoan.com



%d bloggers like this: