I have a lot of WordPress sites I manage and I’ve been thinking about converting them to WordPress MU sites to consolidate management. Today I attempted the first one, about.Scriblio.net. There’s no proper way of doing it that I found, but here’s what I did:

• Create a new site in MU
• Create the users in the correct order (user ID numbers must match)
• Replace the posts, postmeta, comments, terms, term_taxonomy, and term_relationship tables with those from the original blog
• Copy the contents of wp-content/uploads to wp-content/files
• Update the posts table with the new path (both for regular content and attachments, see below)
• Hope it all worked

Somebody is likely to say “just export the content in WordPress XML format and import it in the new blog,” but that person doesn’t use permalinks based on post_id. Doing the export/import dance destroys post_id-based permalinks, and that’s a bad thing™.

The MySQL queries to update the posts with the new upload location:

• for “regular content”

  UPDATE {new_posts_table}
  SET post_content = REPLACE(post_content, '/wp-content/uploads/', 'scriblio.net/wp-content/files/')
  WHERE post_content LIKE '%/uploads/%'

• for the attachments

  UPDATE {new_posts_table}
  SET guid = REPLACE(guid, '/wp-content/uploads/', 'scriblio.net/wp-content/files/')
  WHERE guid LIKE '%/uploads/%'

Posted June 5, 2008 by Casey Bisson
Categories: Technology. Tags: conversion, mu, site management, upgrading, wordpress, WordPress MU.

2 Comments

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

 

User contributed tags for this post:

about (5) - wordpress mu import (4) - upgrading from wordpress to wordpress mu (4) - WPMU 2.6 sites (3) - wordpress mu import users (2) - convert wp wpmu (2) - wpmu replace wp (2) - wp to wpmu (2) - upgrading to wordpress MU (2) - converting wordpress to wordpress mu (2) - where is user ID number in WP 2.6 (2) - converting from wp to wpmu (2) - convert wordpress to wpmu (2) - link: www.arab-sex.com (2) - import wordpress wpmu (2) - intaling wpmu on centos (2) - convert wpmu (2) - wordpress import wordpress mu mysql (2) - plugin export wp (2) - from regular wp to wpmu (1) - how to export blogs from wordpress mu and import in wordpress (1) - wpmu blogs exportieren (1) - exporting users to wordpress mu (1) - wordpress mu export import (1) - wpmu to replace wordpress (1) - link: www.sex.tv.com (1) - change wp to wpmu (1) - export wordpress.org to mu wordpress (1) - wordpress mu import posts (1) - import wordpress mu (1) - Wordpress export users (1) - upgrading wordpress.org to wordpress mu (1) - convert wpmu to wp (1) - wpmu on centos (1) - wpmu export users (1) - wordpressMU import (1) - convert mu wordpress (1) - wordpress mu import content (1) - WP convert to wpmu (1) - wordpress mu import with rss (1) - convert wordpress to wordpress mu (1) - import to wp mu (1) - wpmu wp import plugin (1) - wpmu import email (1) - Import posts to wordpress mu (1) - how to export from wpmu to wp? (1) - converting to wordpress mu (1) - converting to 2.6.2 wordpress problems (1) - wordpress 2.6 mu import blog (1) - convert wordpress to WordpressMU permalinks (1) - blog internet wp recent comments archive 2008 (1) - wpmu exporter blogs (1) - convert wordpress to wordpress mu plugin (1) - WPMU Name (required) Website comments blog (1) - how to export site wordpress.org (1) - creating an art site with Wordpress MU (1) - port WP plugin to wpmu (1) - www.bigpussy.comm (1) - wordpress to wordpress mu export import permalink (1) - permalinks plugin wpmu (1) - permalinks wpmu (1) - www.sex mu (1) - upgrading from wordpress to wpmu (1) - export users to wpmu (1) - wpmu sites table (1) - plugin export wpmu (1) - wordpress mu import export move photos (1) - wpmu import plugin attachment (1) - bigpussy.comm (1) - content (1) - wordpress mu (1) - wp-mu to wp (1) - wp 2 wpmu (1) - create a new blog with wordpress mu (1) - wordpress mu import categories (1) - export users into Wordpress mu (1) - wpmu import wordpress (1) - export wordpress to wpmu (1) - wpmu with wp 2.6 (1) - how to export wordpress to wp-mu? (1) - wordpress mu sites (1) - import to mu wordpress 2.6 (1) - import wordpress into wpmu (1) - how to import posts and pics in a wordpress mu blog (1) - www.sex.mu (1) - guid wordpress mu (1) - import regular wp blog in wp mu (1) - importing content to wpmu blog (1) - CONVERTING WP TO XML (1) - Upgrading from WP to WPMU (1) - how to replace an existing site with wpmu? (1) - wpmu mysql searc replace (1) - wpmu create category (1) - wpmu export blogs (1) - move wordpress mu to new site (1) - wpmu download and i port file attachments (1) - import wp users wpmu (1) - using democracy with wpmu (1) - wpmu import blog (1) - WPMU based site for private accommodations (1) - WP 2.6.2 site doesn't open in IE (1) -